As per attached drawing I have a NAS that store’s, inside a folder named Docs, various Excel files.
The NAS is connected to a Windows 2008 R2 File Server (Server’s name: Office-SRV1)
All clients are accessing the Excel Files having a Map Drive of \\Office-SRV1\Docs
Inside the Excel Files there are
='\\ Office-SRV1\DOCS \ I C \Operations\[LOG.xlsm]……….
=IF(INDEX('\\ Office-SRV1\DOCS \ I C \Operations\[LOG.xlsm]……….
The problem that I am facing is that in case:
1) I change the Server Name
2) The Server goes down
all the internal Excel links and functions will collapse.
I am strictly stuck to Server’s Name although the files are hosted inside the NAS.
How should I overcome this limitation (one idea would be to change the Server name on every excel link
but this is out of scope since the Excel Files are thousands)
Thanks in Advance,