2007 Excel file formats

  • Thread starter Thread starter Ryan
  • Start date Start date
R

Ryan

I have a sheet with a user defined function that will run fine in 2003
however when it is opened in 2007 the function only returns a "#NAME?" error.
Is this a file format issue or something else? Any help would be appreciated.
 
It sounds like the code with the user defined function is not active or
perhaps not even present when opened in 2007.
You may need to save the file in 2007 .xlsm format and even after that you
may have to copy the code from the 2003 file and add it to the 2007 file.
 
Can this be done while keeping the sheet compadible with 2003? It is my
understnading that .xlsm are 2007 documents.
 

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

Compatibility Problem Excel 2003 x 2007 1
problem with macros and protections 5
Formatting lost when saving excel 2003 file using excel 2007 1
Excel Extremely Slow 2
converting excel 2003 to 2007 file formats 18
Excel 2007 from Excel 2003 #N/A Problem 1
Remove Prompt to Open File as Read-Only (Excel 2007) 2
UDF doesn't work on a protected sheet in Excel 2003 1

Back
Top