Formula's breaking links on their own...
I am using Excel 2003 and use a big (28mb) file which has links to 3 or 4 other files pulling a lot of data together.
The file is a Forecast file so there are 20 department tabs formatted exactly the same with the same totals consolidating in a Total tab.
I have had instances recently where on a random department several random formula or link driven cells are now their original numerical values (the links have been broken), so the formula's have been lost.
I have checked the last date the files were saved and confirm that nobody has been in and "toyed" with anything and can confirm that the links have not been broken for all links to the particular file at the time.
Has anybody out there experienced and solved this type of issue before? Or does anyone have any suggestions as to what could be causing this, limitations that could be occuring due to the size of the file or any other observations that i can take away to try and resolve this extremely annoying issue i face??
Many thanks in advance for any input you can give!
Last edited by JRdeeping; 06-12-2009 at 04:27 AM.
Re: Formula's breaking links on their own...
Hi & Thanks
We have changed server fairly recently and are in the midst of changing our links from drive references to full server names as i know that can be tempramental at times.
There are no macro's with in the spreadsheet, but appreciate that could have been causing an automatic hard coding if the shape of the file had changed without the macro being updated.
Do you think it could be the external file links that could be overwriting themselves due to them being linked to drives rather than server names?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1