Solved

Formulas not working when going from excel 2010 to excel 2013

Posted on 2014-12-11
8
50 Views
Last Modified: 2015-01-09
We have financial reports we do every morning that have lots of cell references.  Everything has been working fine using excel 2010.  Just upgraded bosses laptop with excel 2013, and when opening up  the same spreadsheets getting #N/A in many of the cells.  File was saved as an .xlsx.  Please help
Borrowing-Base-Report-12-11-2014.xlsx
0
Comment
Question by:mssantan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 40494213
If you go to the A-R Dollar and A-R Peso sheets, then unhide the rows above Row 172, you will see that the #N/A in those cells are not a result of any formulas.... not sure why.... but you can copy up the formulas from row 172 to the top (except D6 where you have a hard coded entry).  Then all the errors disappear in the Summary.
0
 
LVL 19

Expert Comment

by:Zaheer Iqbal
ID: 40494218
You will more than likely have to re-create the spreadsheet in 2013 format.

Does it have links to other files ?
0
 

Author Comment

by:mssantan
ID: 40494263
It doesn't have links to other files... just references to other cells.

NBVC:  Thank you for your comment... but I don't really understand exactly what I'm supposed to do.  I can unhide the rows above 172, but not sure how I am to copy up the formula's.. what formulas?  and what column/cells to I copy to?
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

Author Comment

by:mssantan
ID: 40494281
And why would everything be fine in excel 2010, but now 2013?
0
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 40494282
Where you see the #N/A errors in column's D and H.  It seems like around row 120, something occurs that makes the rows above contain =#N/A  where the rows below have formulas.

So if you select a cell in column D that shows the real formula, say in D172.  Click and hold the little black square at the bottom right corner of the cell, then drag upwards to D7.  This should bring the formula up.

Now repeat this in column H, copying from H172 up to H6.

Now you will see numeric results.

Repeat in the other sheet.  

Then the Summary should display numeric results.


I am not sure what happened between 2010 and 2013.  It should be okay, unless you were using non-compatible functions (which it looks like you weren't)....

Try unhiding the same rows in 2010 and see if the rows above 120 show formula or error when you select the cell(s).
0
 

Author Comment

by:mssantan
ID: 40494349
Thank you very much... I understand how to fix now.  I did open in 2010 and it does show the same errors.... but yet it is calculating everything fine. That really doesn't make any sense.. but at least I have a way to fix in 2013.  I really appreciate your help.
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 40539829
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel Web Add-in Where is Visual Basic used 9 85
Excel graph in access report 1 34
multiple unique values in different columns 15 36
need count all combination 31 34
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

752 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