I received a file that was created with a previous version. I converted the file and it works on its own, but whenever I tried to copy the sheet to an existing file which i created I get the #NAME? error.
It looks like excel may have deleted or changed some of the old formulas used in the file.
Any suggestions
Thanks for the help
So what cells are the #NAME errors in? I don't see any.
You have links in the spreadsheet to places I cant see and also macros that may need checking.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Sorry, I should have attached both, errors are in the total row in Row 21
Your original file is .xlsm, a spreadsheet with macros.
Your file with errors is just an .xlsx - a spreadsgheet with no macros.
That's why you have the errors, dec2us is one of the macro names.
You need to copy the macros into the .xlsx and save as .xslm filetype
Thanks for the help. I don't know how to do that though, any suggestions?
Open the .xlsm file.
Alt-F11 to go to the VBA Editor.
Select the code on the right (Ctrl-A)
Go to the new file you updated.
Alt-F11
Select Modules / Insert / Module
Paste the code (Ctrl-V)
Go to the spreadsheet and refresh F9 or select each cell thats got the error, F2 and hit enter.
Hopefully the errors will now disappear using the above
If they've all gone File / Save As and change the File Type to .xlsm at the bottom of the Save As window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks