ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Updating source data links (https://www.excelbanter.com/charts-charting-excel/262517-updating-source-data-links.html)

2a1d

Updating source data links
 
Hi all,

I'm having a small (major) issue with editing my links from graphs and data when moving the file of the original source.

I'm rearranging my drive as it's just turned into a bit of a mess and I'm looking to just start over with new folders etc..
However I'm going to become unstuck when moving some of these files as I have thousands of charts and data that will be affected if I move the source data.

ie.
Analysis/UPG/March2010/Meeting
to
Reporting/March2010/Output

I've read around and seen the option of edit links but this isn't entirely feasible due to the thousands of links which will need to be changed.

Is there another way around this at all?

Any help would be very much appreciated

Thanks


All times are GMT +1. The time now is 02:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com