Linking workbooks; experiencing random "#n/a" error
I am attempting to link multiple (~35) workbooks from a single source. The
destination workbook is displaying "#N/A" on some cells, while others (with the same protection properties) are updating without issue. A little more info: The source and destination workbooks are identical in terms of formatting, cell locations and tabs. The destination workbook has been created by selecting cell ranges and then utilizing the "paste link" function. The destination workbooks must also be protected at both the workbook and sheet levels. Any assistance is greatly appreciated! |
All times are GMT +1. The time now is 09:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com