Paste Links not updating automatically.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet with 97 individual tabs. One tab is the complete
report, the other 96 tabs are paste links pulling from the main spreadsheet.
I have the issue where the paste links on the 96 tabs will not update
automatically. Each cell must be double clicked on and then the info will
pull through correctly. Formulas are correct, and auto calculation is turned
on.

I have never had this happen on any other spreadsheet. Does anyone have
advice or encoutered a similiar situation?

Thanks
 
Try selecting all the cells on that worksheet.
Edit|replace
what: = (equal sign)
with: =
replace all

Maybe it'll wake up excel's recalculation engine.
 

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

Using paste link 1
change multiple links at once 1
Keeping formulas that reference a tab that changes daily? 3
Help - Auto update from multiple spreadsheets 5
User is not prompted to update links when opening spreadsheet 2
Link To File That No Longer Exists 1
#N/A In Cells 7
Update one worksheet tab to automatically update all other tabs? 1

Back
Top