mssantan
asked on
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
Borrowing-Base-Report-12-11-2014.xlsx
Last Comment
NBVC
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.
You will more than likely have to re-create the spreadsheet in 2013 format.
Does it have links to other files ?
Does it have links to other files ?
ASKER
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?
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?
ASKER
And why would everything be fine in excel 2010, but now 2013?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
