PDA

View Full Version : Not able to retrieve historic values - link updating issues



musicgold
11-30-2010, 09:54 AM
Hi,

I have an Excel file that has formulas that are proprietary to a custom application. The formulas used to pull values from the application. A copy of the file has been saved as of Dec 2007. We no longer use the application.

When I try to open the file to see the values as of Dec 2007, I am getting a prompt (Remote data not accessible) asking to update the links to the custom application. I can see the values while the update link box is being displayed. However as soon as click Yes or No on the update link box, the values turn into #NAME values.

Is there a way I can retrieve the values?

Thanks,

MG.