Trouble Linking Cell Values from One Sheet to Another

Steph32847

New Member
Joined
Nov 21, 2005
Messages
1
I am using an old file I have updated for a new task since the old file has the format needed. My question is when I set up a formula in a cell on one sheet that points to the value of a cell in another sheet of the same file using =Sheet2!D20, this does not always work (I am not able to click into the cell of the second sheet); is the cell locked on one of the sheets? I have checked everywhere I know to try to get this to work in this file. I am using Excel 2000 SP3 and if I create a new file, I do not have the problem.

Thank you for any help you can offer.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
You do not need to manually select the cell on the target sheet in order to complete the formula. You can do exactly as you did here and merely type the formula in the formula bar without ever leaving the first sheet.

For example, if I am on Sheet1, in cell B3 and want to reference (sum) a range on Sheet2, all I need to do is:

1. Select cell B3 on Sheet1
2. Type in the cell or formula bar my formula:
____ =SUM(Sheet2!A1:A100)

(The leading underscore is just to for illustrative indentation)
 
Upvote 0
Welcome to the board!

Yes, you don’t need to select the referenced cell in the source sheet, but maybe it is locked: Tools – Protection. If it is protected Protections first choice will be Unprotect Sheet.

A new sheet (file, workbook) is unprotected by default.

Hope this helps

RAM
 
Upvote 0

Forum statistics

Threads
1,211,839
Messages
6,104,295
Members
447,901
Latest member
boy3hc2004

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top