How to stop #REF! on linked cells in complex spreadsheets
Is it because you are linking to a pivot table? Or are you linking to plain
data/text fields? "Fatsofoureyes" wrote: I have a spreadhseet with links to several workbooks involving complex functions. If the linked workbooks are all open there is no problem. If I save the spreadsheet and re-open when the linked wworkbooks are shut all the formulas show as #REF! How can I stop this happening |
All times are GMT +1. The time now is 11:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com