My colleage and I set up a intranet website among the network drives using Excel spreadsheet. There are graphs on the worksheet that are linking to other files which updates automatically. Recently, the links to the drive seems got screwed up for some reason, but when I tried to change it back, Excel won't allow me... for example...
Good Link: \\Servername\Website\Link\[File.xls]$B$2
became,
Bad Link: \\Servername\Website\Website\Link\[File.xls]$B$2
Does anyone have an idea what might have caused this and how to fix the problem?
I have numrous macros running every 15 mins to update the website.
Good Link: \\Servername\Website\Link\[File.xls]$B$2
became,
Bad Link: \\Servername\Website\Website\Link\[File.xls]$B$2
Does anyone have an idea what might have caused this and how to fix the problem?
I have numrous macros running every 15 mins to update the website.