Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Links not updating automatically.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Paste Links not updating automatically.
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. Debbie H wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why not automatically updating calculations? | Excel Discussion (Misc queries) | |||
Updating a chart automatically | Charts and Charting in Excel | |||
Excel 2003 links are not updating between workbooks | Excel Worksheet Functions | |||
?? Links Not Updating ?? | Excel Discussion (Misc queries) | |||
Links updating? | Excel Discussion (Misc queries) |