BudParker
New Member
- Joined
- Sep 16, 2008
- Messages
- 16
When copying a tab in the spreadsheet a Popup Message appears, saying,
"A formula or sheet you want to move or copy contains the name ‘_bas1’, which already exists on the destination worksheet. Do you want to use this version of the name?"
It cycles through a total of 6 times, each new popup window with a different "name"; _bas1, _bas2, _bas3, _bas4, Database, and Entry.
Of course, each popup requires a decision to either rename the range or enter a new name in the Name Conflict dialog box.
This spreadsheet has a date of the month represented by a tab for each new day, hence the copying of the tab.
This is not a particularly complex spreadsheet, just a list of changing names and assignment locations. Any idea what is causing these popups and how to prevent them? I will express my appreciation in advance for your efforts.
"A formula or sheet you want to move or copy contains the name ‘_bas1’, which already exists on the destination worksheet. Do you want to use this version of the name?"
It cycles through a total of 6 times, each new popup window with a different "name"; _bas1, _bas2, _bas3, _bas4, Database, and Entry.
Of course, each popup requires a decision to either rename the range or enter a new name in the Name Conflict dialog box.
This spreadsheet has a date of the month represented by a tab for each new day, hence the copying of the tab.
This is not a particularly complex spreadsheet, just a list of changing names and assignment locations. Any idea what is causing these popups and how to prevent them? I will express my appreciation in advance for your efforts.
