Question about Computers & Internet

1 Answer

Link in excel 2007

How can i Create an external reference(link) between cells in different workbooks in excel 2007
please tell me how to make this in details
thank you in advance

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Vice President:

    An expert whose answer gotĀ voted for 100 times.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

  • Expert
  • 163 Answers

Right click on any cell then select hyperlink option from the list then a dialog box will appear infront of you
in left hand side pane there is option place in this document click on that then in right hand side pane select sheet 2 or sheet 3 whichever you want...
or if you want to open any other file so use existing file...option

Posted on Jul 05, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Unable to open EXCELL 2007 workbook containing a circular reference problem.


open Excel
Click the 'Microsoft Office' button and click 'Excel Options'. Click the 'Formulas' button. From 'Calculation options' section, un-select the 'Automatically' option. then use file->open->yourfile.xlsx. It should now open. Find the circular reference and fix it. Then save the file.

Mar 18, 2013 | Microsoft Office Excel 2007 Full Version...

2 Answers

What is a workbook?


A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages or worksheet

The term spreadsheet is often used to refer to a workbook, when in actual fact, spreadsheet refers to the computer program, such as Excel.

So, strictly speaking, when you open the Excel spreadsheet program it loads an empty workbook file consisting of three blank worksheets for you to use.


Jun 25, 2011 | Microsoft Office Excel 2007 Full Version...

1 Answer

My Excel 2007 status bar shows the words "Calculate" even though my calculation is set to automatic. From my experience with the prior version of Excel, this indicates a circular reference error....


A couple of possible causes:

Setting Workbook.ForceFullCalculation to True will cause this.

The Iteration Option is turned on and the workbook contains circular references. Turn off Iteration (Tools-->Options-->Calculation) and press F9-- it may show "Circular Reference."

Jun 20, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Excel 2007: Conditional formatting


did you put the sheet name in your reference? ex =Sheet2!A1 or you can name the cell ranges on the other sheets and use the cell names in your conditional formatting formla.

May 08, 2009 | Microsoft Excel for PC

1 Answer

Copy and paste between different workbooks


There should be 2 paste options when you right click in the new workbook - 'paste' and 'paste special'

choose 'paste special' and make sure that 'All' is selected not 'values'

Apr 24, 2009 | Computers & Internet

2 Answers

Sharing Problem


some colors are not available in office 2003

under (office 2007) excel options (alt-t-o), save tab, you can choose which colors will be seen in previous excel versions.

Sep 23, 2008 | Microsoft Office Professional 2007 Full...

5 Answers

Forgot password to open Excel sheet


If you mean that you can open the Workbook and read the Worksheet - then all you have to do is select all and paste it to another Worksheet. This will allow for changes of formulas etc.

If you mean the whole Workbook - then I dunno.

In future, either use the same password for everything (easy to remember) or Protect the work with nothing entered into the password field (leave this blank). This last will protect the work from people who try to guess your password, but will be easy for you to remember - eg every password is left blank.

If you must use unique passwords, then keep a record of them somewhere other than on your computer.

Sorry I can't help with the "Workbook" solution - but somebody else out ther may be able to do so.

Apr 25, 2008 | Microsoft Office Professional 2007 Full...

2 Answers

Budgets in excel


Dear Madiha35,

 

I would recommend the use of the Table Function in Excel.

 

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

 

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

 

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

 

Step 1:  Enter your data into the worksheet.

 

Step 2:  Create Table

             Highlight the relevant data

             On the insert tab, click on Table

             

Step 3:  Verify Table range is correct, Click OK

 

Step 4:  Select the cell you where you wish to Sum Data.

         Click on Autosum.

 

Step 5:  To Insert new data

         Click on the sum row in the table, (Not the entire worksheet row)

         Right click, Insert, Insert Table rows from above

 

Step 6:  Enter new data in row

 

Step 7:  Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

236 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...