View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JeffJake
 
Posts: n/a
Default I get error messages in Excel cells once I save a file

When I open a certain Excel spreadsheet from an e-mail attachment, all cells
operate fine, and all calculations work. Once I save the file on my
computer, and re-open it, I get a lot of #NAME? errors. These seem to refer
to cell names that don't exist in my file, like worksheets that may have been
removed from the file before it was sent to me. How do I save the data
correctly, without the error messages appearing?