Major and Minor Loss of Fidelity in Excel

[Luke]

I"m getting this message a lot for a spreadsheet I use, and I'm losing data and having formatting issues.

Isn't a spreadsheet I created, so I'm guessing that the guy who sent it to me isn't using "the XP Excel", but it's giving me a lot of work to do. When I click on the "help prompt" nada happens.

Any suggestions or ideas other than buying new software?

[isiolia]

Excel did gain significant capability going from the old .xls format to .xlsx (in Excel 2007), including much larger maximum cell count and more formatting options. I'd do a Save As, make sure it's saving as the current file type, and see if you still get the warnings and lose work.
From what I've seen from a brief Google search though, the common cause of those errors is saving back to .xls when it can't fully accommodate what's in your file.

If whoever sent you the file is still on Office 2000 or 2003, then they could possibly install the compatibility pack to work with .xlsx. Or they might have a newer version, and it's just an old file they never converted.

[Luke]

Excel did gain significant capability going from the old .xls format to .xlsx (in Excel 2007), including much larger maximum cell count and more formatting options. I'd do a Save As, make sure it's saving as the current file type, and see if you still get the warnings and lose work.
From what I've seen from a brief Google search though, the common cause of those errors is saving back to .xls when it can't fully accommodate what's in your file.

If whoever sent you the file is still on Office 2000 or 2003, then they could possibly install the compatibility pack to work with .xlsx. Or they might have a newer version, and it's just an old file they never converted.

Sorry to go back to a 2001 meme, but "I KISS YOU!".

Great information, and I really appreciate it.

[ExedExes]

This site might have some more info too. I've never heard of those errors in Excel, but I know how much of a pain Word and Power Point files can be when made in different versions.