.xlsx opening in 2013 "automatic update of links disabled" - has #REF! in cells but opens fine under 2007
Posted on 2014-08-08
We are using a spreadsheet (not mine) and it is created under Excel 2007. I am testing Excel 2013 and when I receive the spreadsheet, all of the cells show #REF! and I get the message saying that "automatic update of links disabled."
When I try to enable them and update, it can't find the .xlsm file that I guess the spreadsheet is referencing??? Doesn't matter if I try to update the links or not, it still won't show the data.
This works under Excel 2007...I get the same message about the "links being disabled" but by default, on 2007, I can see the data.