Updating Excel spreadsheets
Hi
If I had an Excel spreadsheet with linked data to another and I created another 'identical' spreadsheet, would the sheet update automatically if I overwrote the old spreadsheet? Anyone got any ideas? Thanks! |
Updating Excel spreadsheets
That should work, if the file name is the same, sheet name is the same, and
location of data is the same. "kachasu" wrote: Hi If I had an Excel spreadsheet with linked data to another and I created another 'identical' spreadsheet, would the sheet update automatically if I overwrote the old spreadsheet? Anyone got any ideas? Thanks! |
Updating Excel spreadsheets
THANKS VERY MUCH -I'LL TRY THAT, BUT WILL MAKE A BACKUP OF THE ORIGINAL SHEET
IN CASE.. MUCH OBLIGED! "dlw" wrote: That should work, if the file name is the same, sheet name is the same, and location of data is the same. "kachasu" wrote: Hi If I had an Excel spreadsheet with linked data to another and I created another 'identical' spreadsheet, would the sheet update automatically if I overwrote the old spreadsheet? Anyone got any ideas? Thanks! |
All times are GMT +1. The time now is 03:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com