File error: data may have been lost

sdc

New Member
Joined
Apr 3, 2009
Messages
18
I've been working on an Excel file with no problems. Then yesterday I opened it and got the error in the subject line. Certain - but not all - of the formulas in the workbook now simply contain "=#N/A". I fixed the formulas and re-saved it. I opened the file again today and got the same problem. Older versions of the file with the same formulas (maybe slightly different) are opening fine. There are no macros in this workbook. I'm using Excel 2007. Any ideas why this might be happening and how to stop it?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

sous2817

Well-known Member
Joined
Feb 22, 2008
Messages
2,276
I had the same problem and it was because I was using formulas that are exclusive to the Analysis Tool Pak. On one machine, the Tool Pak was installed, and no issues. On another machine, the Tool Pak wasn't installed and I was getting the error.

Not sure if your problem is along the same lines, but it sounds like it.
 

sdc

New Member
Joined
Apr 3, 2009
Messages
18
That does sound like it's along the same lines - the formulas that are breaking are include XIRR, which I believe is part of the Analysis Tool Pak.

However, I'm on the same machine and using the same version of Excel and had no problem with these formulas a day before, and still have no problems when I open up earlier versions of the file that contain XIRR.
 

sous2817

Well-known Member
Joined
Feb 22, 2008
Messages
2,276
Here's a shot in the dark:

Did you send the file to someone, they opened (perhaps they didn't have the Tool Pak installed), saved it, and then sent it back to you?

That's what happened to me, and the errors started popping up. On their machine, it looks like it works, but if you check the formulas it will show =#NA. The value is still there, but the formula isn't.

I fixed it by adding in a bit of code on the workbook open event to make sure the tool pack was installed.

Welcome to the board, by the way! Sorry, didn't catch it earlier.
 

sdc

New Member
Joined
Apr 3, 2009
Messages
18
I didn't send the file to anyone, so that's not it. This is driving me crazy.
 

sdc

New Member
Joined
Apr 3, 2009
Messages
18
I just noticed that on another tab I am getting the same errors even where calculations do not involve XIRR or anything from the Analysis Took Pak. Very odd.
 

sdc

New Member
Joined
Apr 3, 2009
Messages
18
One last bump in case anyone knows what this might be. Thanks.
 

djzachary

New Member
Joined
Sep 23, 2004
Messages
21
I am having this EXACT same problem!!!

My workbook is HUGE though (15 tabs with 1000+ formulas on each, file size is 10mb), so I thought perhaps there might be a limit to the number of formulas that can be contained in a workbook. I'm not aware of formula limits, but has anyone heard of any?

I am using Excel 2007, but saving the file as Excel 2003 since my client has not upgraded. Could this be the issue perhaps? I get some minor incompatability warnings when saving, but nothing that I would expect to cause formulas to be replaced with "#N/A"

I am NOT using more than 255 columns or 64k+ rows, so that is not the cause either.

Any thoughts here would be GREATLY appreciated!!!
Thanks in advance!

Zach
 

Watch MrExcel Video

Forum statistics

Threads
1,099,964
Messages
5,471,739
Members
406,780
Latest member
Todd Gentry

This Week's Hot Topics

Top