Solved

Formulas not working when going from excel 2010 to excel 2013

Posted on 2014-12-11
8
44 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
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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

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 46

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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