DavidB1175
New Member
Hi, I have a rather large worksheet for Chart Data that is for different charts within the workbook but the cell references are pointing to another workbook. I want to replicate the charts and chart data from fiscal year (FY18) to fiscal year (FY19) and also change the months date to 2018 and 2019 using Find And Replace. I have about 200 rows with 12 columns, one for each month. My question is, how can I keep Excel from trying to find the old file and the corresponding worksheet to just change the numbers within the cell references until they are all updated and then ask Excel to update the workbook. Thanks, David
=SUM('U:\4 Statistics\FY18 Monthly Statistics Systemwide and Branch\[Library-System-FY-2018-Stats.xlsx]Oct2017'!$B$58)
I realize the file name is rather long as the main file is on a Network shared drive and its named as such for others to find it. If I can just change 18 to 19 and 2017 to 2018 it will save a lot of work.
=SUM('U:\4 Statistics\FY18 Monthly Statistics Systemwide and Branch\[Library-System-FY-2018-Stats.xlsx]Oct2017'!$B$58)
I realize the file name is rather long as the main file is on a Network shared drive and its named as such for others to find it. If I can just change 18 to 19 and 2017 to 2018 it will save a lot of work.