![]() |
linked cells to workbooks in different folders
I have 3 separate folders, folder(a) contains a workbook that has worksheets
linked to other workbooks in the same folder, folder(b) contains a workbook that has worksheets linked to other workbooks in the same folder, folder(c) contains a workbook that has worksheets linked to workbooks in each (a) and (b) folders. When I copy all the folders to another network path folder only the worbooks in folder (a) and (b) have there paths changed automatically but the workbook in folder (c) still shows the original workbook path locations. I need to individually change the path via the "Edit/links/change source" function and in some cases I get the error message "path or formula to long". Does anyone know why the path doesn't change automatically? |
All times are GMT +1. The time now is 12:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com