Move or Copy spreadsheet issues
Some improvements while using MOVEORCOPY a spreadsheet to another file:
The destination selection window always shows an incorrect name of the target file already opened in the program, e.g. “unnamed.xlsx”, “spreadsheet2.xlsx”, or another default name, although the user-assigned name exists. Despite this, the move/copy operation is correct.
After a spreadsheet is copied to another file with the MOVE or COPY command, cells immediately get a #NAME error and lose values. In MS Office, there is a window asking whether to update the links or not. This would allow to retain data although sources are unavailable in new file.
1
vote