Updating links
I selected to update the links when I open my spreadsheet, because I was
given a new worksheet to link to (so i just renamed this new sheet LINKEDsheet as before, and saved the old linked sheet under a new name LINKEDsheet1) The new information shows up, but after 2 minutes the numbers magically change back to the old sheet's values... How can this happen if my workbook is no longer linked to the old info, and how can i prevent this from happening??? ***I was told that if the LINKEDsheet is open, the update stays current, but if it's not open, it will magically change back...*** |
All times are GMT +1. The time now is 04:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com