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 |
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 |
All times are GMT +1. The time now is 09:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com