Forum Discussion
Solved
Updating month contained in link without changing the rest of the existing link.
Each month, I prepare financial reports on all current projects. We copy the workbook from one month to the next so initially the report contains the info from the previous month. I then have to upda...
- I completely agree with John's comment above and highly recommend you discuss with him ways to improve the sheets and whole process. A singly input sheet and creating output tables/reports/pivot tables ect... can not only make this ongoing process much better, more efficient but may let you do analysis over months that you never realized you could do.
That all said, the simple answer to your question (although I almost think I shouldn't tell you so you take the above suggestions more seriously) is to use Search and Replace and click replace all. In your example a search and replace all for:
2023 NOVEMBER\[4. NOV SOUTH
replace with
2023 DECEMBER\[4. DEC SOUTH
should be specific enough to never have any accidental changes but you could just include more of the link to be sure.
SukiLuLu I agree with the previous comments that it is not the best practice to have a sheet with external links, particularly that many.
A better approach would be to import the data using Power Query, and then you could change the source file path each month, you could even use more advanced Power Query techniques in having the source file path in a named range cell.
Other simpler options, but not as effective or considered best practices would be to use replace all as previously suggested. Or go to data menu and click on Edit Links and Change Source, this could work well if you only have 1 or not too many sources, but would be definitely easier than updating 100 links manually.