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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,010
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,136,272
Messages
5,674,756
Members
419,525
Latest member
helensesc

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