Solved

save excel 2010 with nested formulas into a compatible version for 2007

Posted on 2014-11-10
10
268 Views
Last Modified: 2014-11-12
I have a few locations that are running 2007 version of office.  At the home office we use 2010 or 2013.
We have some excel documents that are using nested formulas that requires 2007 or above to work.
How can I save them as 2007 in 2010 or is there a compatibility pack I can install other than compatibility service pack 1 and 2 for office 2007?

If I save them as 97-2003 then the nested formulas do not work.

Thanks!
0
Comment
Question by:bbimis
  • 3
  • 3
  • 2
  • +2
10 Comments
 
LVL 7

Expert Comment

by:tomfarrar
ID: 40433813
What happens if you just open the 2010 file using Excel 2007?  Do the formulas work?
0
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40434378
Hi,

What are the formulas?

Regards
0
 
LVL 31

Assisted Solution

by:Rob Henson
Rob Henson earned 167 total points
ID: 40434568
Why are you saving as 97-2003 when you say you need compatibility with 2007?

From 2007 onwards the majority of the functions have stayed pretty much the same, the number of nested functions went up to 64 (2003 and prior only had 7). I assume you don't have more than that.

The following link shows restrictions for Excel 2010
http://office.microsoft.com/en-gb/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=1

Thanks
0
 

Author Comment

by:bbimis
ID: 40435157
functions do not work if ran on 2007 with compat packs installed.
I say 97-2003 because that appears to be the closest option I have for xls.
0
 
LVL 31

Expert Comment

by:Rob Henson
ID: 40435189
So, to repeat earlier question, which functions are not working?

Saving as 97-2003 will only make things worse.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Author Comment

by:bbimis
ID: 40436035
understood that's what I'm trying to save it in 2007 format.
as for what functions are not working. it would be all the functions that work in 2010s version. Can't list them.
0
 
LVL 31

Expert Comment

by:Rob Henson
ID: 40436078
I am not aware of any functions that are new to 2010 that wouldn't work in 2007. Please supply some examples of functions that aren't working.
0
 
LVL 4

Assisted Solution

by:C. Blaise Mitsutama
C. Blaise Mitsutama earned 333 total points
ID: 40438542
bbimis, there is no special compatibility pack for saving a 2010 file as 2007. There are no significant changes to functions in 2010 that would break if opened in Excel 2007. There may be something else in the way the functions are used or in the capacity updates between 2007 and 2010 that may be causing the problems you're seeing.

It would be useful to see the nested IF statement(s) you're using, the size of the data set(s) the functions are operating on, where the data is stored relative to the Excel file (e.g., is all the data contained in the Excel file itself or is the data located on a server or in a folder), etc.

Blaise
0
 
LVL 4

Accepted Solution

by:
C. Blaise Mitsutama earned 333 total points
ID: 40438549
Also, I note that you state: "I say 97-2003 because that appears to be the closest option I have for xls." Why are you trying to save the files as .xls? Excel 2007 can use .xlsx files. If you are trying to save .xls (Excel 97-2003) files, the nested functions may be breaking because there was a limit of 7 nested statements in Excel 2003. Excel 2007 and 2010 can both have up to 64 nested statements, and both 2007 and 2010 use the file extension .xlsx.

Blaise
0
 

Author Closing Comment

by:bbimis
ID: 40438708
thanks figured it out.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Outlook Free & Paid Tools
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now