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

Working outlook via vba code with xlsx - error 0
Paste to excel from word - auto format problem 1
Embedded Excel into Word with Tables 0
Merging from an Excel file with graphics 1
Excel 2003 & 2007 formula compatibility 0
Excel 2007 --> 2003 Compatibility 2
Excel 2007 0
Embed the same Excel multiple times 0

Top