Dear Exel forum,
I'm currently working in a large excelfile in which I have many columns of information which are linked to other spreadsheets which are CSV exports from our accounting software program (Minox).
Now the thing is that many of these require monthly updates which I now have to do manually by Replacing the source CSV document name in many different functions. This is both time consuming and rather complex since the functions have up to 5 references to external sheets. As a result, I have been trying to circumvent this inconvenience by replacing the old file by the new one with exactly the same name and location. Unfortunately, this still gives an "reference" error and means many manual fixes.
So the question is, is there any way to have excel automatically update the functions by replacing a source file?
Thank you for your help!
Bookmarks