Named Range Error (Need help troubleshooting and fixing)

[onthegreen03]

Hi. I have a tab that I am trying to copy to a new file. The tab I am trying to copy has one named range, the new file does not. When I copy the tab into the new file I get #NAME? errors in all of the cells with formulas. What do I need to do to get this tab to copy over to the new file without any cell errors? (The formulas work fine in the tab before I move it.) Let me know if you need more information to help troubleshoot the issue, and thanks for the help.

 

[ThatOneDude]

Is the named range on the sheet you're copying or is it on a sheet that doesn't exist in the new workbook?

 

[onthegreen03]

Is the named range on the sheet you're copying or is it on a sheet that doesn't exist in the new workbook?

The named range is on the sheet I am trying to copy into a new workbook. The new workbook has no named ranges so I don't understand why there would be a conflict or error by simply copying that sheet into a new workbook. It has me stumped.

 

[ThatOneDude]

In the Name Manager, is the scope of the named range set to a specific sheet or does it say Workbook?

 

[Joe4]

I do not have this issue.

How exactly are you trying to copy the data over to a new workbook?

 

[onthegreen03]

In the Name Manager, is the scope of the named range set to a specific sheet or does it say Workbook?

Specific sheet (the name of the sheet being moved and coincidently the only sheet in the existing workbook)

 

[onthegreen03]

I do not have this issue.

How exactly are you trying to copy the data over to a new workbook?

I am using the Move or Copy feature (right clicking on sheet name)

 

[onthegreen03]

I do not have this issue.

How exactly are you trying to copy the data over to a new workbook?

Also of note, I inherited this sheet from someone else. It calculates uptake curves and is using a formula (@uptake) that I haven't seen or used before. Maybe it has something to do with that? See below.

 

[Joe4]

OK, looks like you have a lot more going on there.
Are you sure that there aren't any cells/formulas/ranges on this sheet trying to references cells from other sheets?

What might be a better option is to simply re-save the file with a new name, and then delete the sheets you don't need.
If you still get errors, that is a big clue that your sheet is referencing things on other sheets.

 

[onthegreen03]

Thanks, I will give that a try.