Help! Links aren't updating

A

AndysPhishin

I have a very large spreadsheet that has cells that reference othe
cells in other tabs withing the same workbook. However they hav
stopped updating. These are simple links (='TAB'!CELL), but when
change the value in the source cell, the linked cell is not changing.
The only think I have found to work is to F2 into the cell with th
link, then <enter> out and it refreshes. Due to the vast number o
references in this workbook, this will take forever!

Any ideas on how to get the workbook to refresh all links withi
itself?

Thanks!

Andre
 
D

DDM

Andy, try Tools > Options > Calculation, and ensure that calculation is set
to Automatic.
 
A

AndysPhishin

I tried every combination of Shift, Alt, Ctrl and F9... Ctrl+Alt+F
worked! A little message displays quickly at the bottom left corne
saying "Calculating Cells 0%".

Hope this helps someone in the future!

Andre
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why aren't links between tabs in same workbook automatically updat 1
My workbook links are not updating (its 30,000 KB size workbook). 1
Updating Links from Closed Source Workbooks 2
cells linked from worksheet to worksheet 1
links not updating? 7
Please Help! Cells not updating... 3
Link info is showing rather than the data 3
Updating Links within Workbook 1

Top