Cell referencing not working all of a sudden

mike21mcd

Board Regular
Joined
Sep 6, 2006
Messages
67
Hi,
I have a spreadsheet with multiple worksheets. I import data from another application into "Worksheet A". I then use "Worksheet B" to reference about 20 cells in "WS A" so that I can have the data in the format that I need. My "Worksheet B" references are simply ='Worksheet A'!B23 for example....certainly nothing fancy. However, when I import new data into Worksheet A, Worksheet B does not pick up the new data.....it simply reads with the old data.

For an experiment, I tried referencing a cell in Worksheet A to Worksheet A (i.e. referenced D5 to equal B5) and when I changed the data in B5, D5 would not change.

Does anyone know what is going on with the referencing? Why would it automatically stop doing it, did I hit something without knowing it? Any help would be greatly appreciated.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
Is calculation set to manual? (Tools --> Options --> Calculation)
 

mike21mcd

Board Regular
Joined
Sep 6, 2006
Messages
67
yes it is, with the recalculate before save checkbox under that checked as well.
 

mike21mcd

Board Regular
Joined
Sep 6, 2006
Messages
67
Oaktree - I switched to Automatic and it seems to be working now. Thanks again for you help (please let me know if it is more than that). Very much appreciated.
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
If you click in the cell with your formula and press return, does it update with the current values?


EDIT: If calculation is switched to manual, the formulas will only recalculate (and thus update) if F9 is pressed.
 

Forum statistics

Threads
1,172,173
Messages
5,879,463
Members
433,434
Latest member
skk0048

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
Top