Tuesday, March 15, 2016

Fast Solution to Problem: 2007 save as 2003

2007 save as 2003

I got the error message when saving a 2007 workbook in 2003 format that "a reference was outside the sheet limits or function was not supported or formula limits not supported" etc,
I narrowed it down to this
In a new workbook Sheet 1 cell  A1 the formula is =ADDRESS(2,1)
Which returns $A$2
Thats it nothing else
Trying to saveas 97-2003 results in the error message
I know this function is in the older version and the file is created when I click ok, so why am I getting the error message.

Keys to the Problem 2007 save as 2003

Download SmartPCFixer to Fix It (Free)

Excel 2010 has a slightly different message: "Defined names or formulas in this workbook may display different values when they are recalculated in an earlier version of Excel if they reference cells outside of the row and column limit of an earlier version",
which explains it a little better.
I assume that Excel's checking automatically chucks out that message when the ADDRESS function is used, as the check would not actually "calculate" the formula to find out whether your arguments fit within the boundaries of earlier versions.

Steve D.
Demonstration file available on request.

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 Fix the Problem: 2007 save as 2003:



How to Fix 2007 save as 2003 with SmartPCFixer?

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

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

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

Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: Fast Solution to Error: 2010 starter preloaded product #,16 bit program using window 7 virtual xp [Solved],How to Fix - 2010 Access Macro - Error?,Troubleshoot:2 windows, file download and run save cancel Error,Tech Support: 2010 Word Download location? Macro Errors?,IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32

No comments:

Post a Comment