marcusblackcat
New Member
- Joined
- Mar 11, 2015
- Messages
- 18
Hi everyone - I have a user with an excel file which, when he right clicks on a row number and selects "delete", it deletes only the data and does not move any of the cells.
If he right clicks, within the same file, and selects "delete", then selects either "Shift cells left" or "Shift cells up" or "Entire row.colum" it deletes the data and leaves a blank cell with no formatting.
It only seems to happen on this one file and, if he saves this locally (it is on SharePoint) it works fine.
It has completely baffled me. There are no Macros active on the worksheet/workbook modules to make this happen. Only active macros are in individual modules and have nothing to do with cell formatting/clearing/changes.
Same file works fine for all other users (which makes me think his Windows profile may be to blame somehow)
All other files work fine on his computer UNLESS this problem file is open.
Apologies if it is not an Excel issue but any advice would be gratefully received
If he right clicks, within the same file, and selects "delete", then selects either "Shift cells left" or "Shift cells up" or "Entire row.colum" it deletes the data and leaves a blank cell with no formatting.
It only seems to happen on this one file and, if he saves this locally (it is on SharePoint) it works fine.
It has completely baffled me. There are no Macros active on the worksheet/workbook modules to make this happen. Only active macros are in individual modules and have nothing to do with cell formatting/clearing/changes.
Same file works fine for all other users (which makes me think his Windows profile may be to blame somehow)
All other files work fine on his computer UNLESS this problem file is open.
Apologies if it is not an Excel issue but any advice would be gratefully received
