Dear All,
I got a problem when moving(creating a copy) a sheet in the same filename.
It says
" a formula or sheet you want to move or copy contains the name '_Fill", which already exists on the destination worksheet. Do you want to use this version of the name?"
I don't know what does this means.
Thank you.
Rey
Stating the obvious it means exactly what it says.
If you have say A1 in file 1 that is named say 'myname' and in file 2 you also have a name 'myname' which may or may not refer to A1, Excel need to know which name should, be used. When you copy or move a sheet all names transfer with the copy hence there has to be a resolution when merging with a file that already contains the same name whether the name (and hence cell) on the destination file should be used rather than the name/cell on the original sheet.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thank you Richard Butterfly. but what i mean is that when you copy/move sheet, that statement appears before you can copy/move the file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks