Excel 2007 from Excel 2003 #N/A Problem

S

Scott

I have just migrated from Excel 2003 to Excel 2007 and am experiencing
problems with functions that were built into the analysis toolpak in 2003,
but are functions in Excel in 2007. I have a spreadsheet that I created a
while back in Excel 2003 that has formulas containing the EOMONTH and MROUND
functions. When I save this file in Excel 2007, I get an error message
saying "File Error: Data may have been lost" and all of my formulas
containing EOMONTH and MROUND functions are replaced with "=#N/A". Does
anyone know how to fix this compatibility issue between Excel 2003 and Excel
2007 for these functions? Thanks for your help!
 
J

Jacob Skaria

Both these functions should work with 2007. Can you try these functions in a
fresh 2007 worksheet.

If this post helps click Yes
 

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 2007 --> 2003 Compatibility 2
Compatibility Problem Excel 2003 x 2007 1
MROUND 1
Excel 2003 sheet containing look ups won't open in Excel 2007 3
Excel 2007 - keyboard functions 2
Excel 2007 Analysis Toolpak 7
Excel 2007 does not save formula 2
Add-in functions 6

Top