Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 90
  • Last Modified:

Formulas not working when going from excel 2010 to excel 2013

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
mssantan
Asked:
mssantan
1 Solution
 
NBVCCommented:
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
 
Zaheer IqbalTechnical Assurance & ImplementationCommented:
You will more than likely have to re-create the spreadsheet in 2013 format.

Does it have links to other files ?
0
 
mssantanAuthor Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
mssantanAuthor Commented:
And why would everything be fine in excel 2010, but now 2013?
0
 
NBVCCommented:
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
 
mssantanAuthor Commented:
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
 
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now