人気ブログランキング | 話題のタグを見る

[Solved] EOMONTH turns to =N/A when opening working Excel 2003 sheet in Excel 2007

EOMONTH turns to =N/A when opening working Excel 2003 sheet in Excel 2007

I am trying to use a file that contains a number of instances of EOMONTH.
The file was created with Excel 2003.
My Excel 2007 usually handles such functions fine (with or without ATP enabled).
However, open opening this file, all the EOMONTH functions have
been replaced by "=N/A", leaving me no way to even determine what cells they were referencing. 
 
A search of Excel forums finds that this is not an uncommon problem, but I haven't found any workaround (some have reported things work better after a reboot--that didn't work for me).
The problem, according to the forum, is often accompanied by an error
message stating that there is a compatibility error and functionality may be lost, but I'm not getting anything. 
 
This problem occurs whether or not ATP is enabled in 2007 at the time I open the file.
 
Any ideas?

Keys to the Problem EOMONTH turns to =N/A when opening working Excel 2003 sheet in Excel 2007

Download Error Fixer (Free)

Yes, this is by-design in Excel 2007.

Analysis Tool Pack add-in must be enabled so that Excel 2003 workbooks will not return the #NA error.
 
Refer the link below on how to enable it:
http://office.microsoft.com/en-us/excel/HP100215691033.aspx
 
Hope it works

Sachin Shetty

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Recommended Method to Repair the Problem: EOMONTH turns to =N/A when opening working Excel 2003 sheet in Excel 2007:

How to Fix EOMONTH turns to =N/A when opening working Excel 2003 sheet in Excel 2007 with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed


Related: Download SONY SVE1512H1RB Synaptics PS/2 Port ClickPad driver,Method to Download SONY VGC-LT10E SigmaTel Audio Driver Update v.6.10.5614.0,Way to Download SONY VGN-CS118E/R AV Mode Button Utility v.1.1.01.09140 driver,Method to Download SONY VGN-FW375J/B Alps Pointing Device Driver v.5.7.0.92,Where to Download SONY VGN-NS270J/S Pioneer BD-ROM BDC-TD01 Firmware Update v.1.03,Data Export From Quickbooks To Excel,Date Format In Formula Bar And In The Cell Is Not The Same,Deleted The Snipping Tool,Desktop - Open Program Issues,Desktop Windows Manager Keeps Poping Up & It Reads That There Is A Problem & That Windows Will Check It Out & Send Me An Answer .
Read More: [Anwsered] error 0x000000ed unmountable boot volume,Tech Support: Error 1079 while starting the audio service,Troubleshoot Erro 789 no windows 7 Error,Troubleshooting:ERROR 1079 when trying to update Direct X,[Solution] ERROR 1079: Windows Audio and Windows Firewall won't turn on.,does anyone know what the dialog means "System.Media.FontFamily' threw an exception windows is checking for a solution?,Does Log Me In Ignition for my Android with Windows 7 Home Premium?,Download failure for my Blackberry and the process stops during the install,Display settings keep changing when I come back from sleep mode,Downloaded files are not saved
by RthdcplExeFree | 2016-10-11 15:43