Excel 2010 file with links - how do we open without updating?
Posted on 2012-09-06
We've recently updated our computers to MSO 2010. Two users have reported that excel spreadsheets that used to have data, now have #ref$ errors. In looking at these particular excel files, I have gone to the Data tab, Connections section and looked at Edit Links. There I find that there are references to two other files which we do not, and have never had. One reference is to an xlsm file and one is to an xls file - but as I said we've never had these files.
The two users report that previously when they received the excel sheet (in either MSO 2003 or MSO 2007), there was data present in all of the cells which now have errors. The file comes from a vendor who is providing the spreadsheet, but has never providing the two other files I see referenced under Edit Links. I have Excel 2010 so cannot confirm how it did or did not work before. I just know that now the users cannot see data, they just get the #ref$ error -- why were they not getting this error with prior versions of Excel.
I have gone into my Excel Settings - File - Options - Trust Center - Trust Center Settings Button - and the External Content tab. Here I have selected "Disable all data connections" and "Disable automatic update of Workbook Links." Then I've attempted to open the excel file and still get the same error.
Any thoughts on how/why this used to work without us having the other two referenced files and how we can make it work again in Excel 2010.