Spreadsheet links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a spreadsheet that has dozens upon dozens of links.
Recently, upon opening this spreadhseet, I noticed that there were still
numbers in a cell that was linked to file that has been deleted. I even
updated but the data was still there.

I would have expected a #REF error because the spreadsheet that this cell
was linked to was deleted. Does anyone know why the data is still showing as
if the file still existed?
 
By default Excel retains that last known value for linked cells, even if the
file is no longer located at its original location on the network.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003, Linked Spreadsheet, Cell Character Count 3
Links error when insert line/row to source workbook 1
Associated Spreadsheets 1
Significant DELAY to open spreadsheets containing regular links? 6
Excel Linking (I think) 17
View spreadsheet without email heading 5
Linking Spreadsheets for Data Validation 4
Links 4

Back
Top