Links reverting
Hi, I posted this question last week but have not recieved any replies, maybe
someone here can help? I have a named range in a source spreadsheet which is linked to other spreadsheets. I edited one of the values in the range but when I run the macro to update the linked spreadsheet, the reference reverts back to the old one, which returns an incorrect value. When I check the source spreadsheet, it has the new changed reference link. Please help! Thanks in advance. |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com