Solve this mystery please...

[pam53154]

We receive monthly Excel files from a service provider. When one of these files is open at the same time as our own spreadsheets we cannot insert or delete rows in our spreadsheets. My first inclination was rogue code, but I saved a copy of their file and removed all code and our row insert/delete problems continued. We inquired and they said "we do not see this issue on our side" (doubtful).

Any ideas? Things to check?

Thanks in advance.

 

[Oaktree]

Can you be more specific on what you mean by "we cannot insert or delete rows"?

How are you trying to insert/delete? Right clicking the mouse? Keyboard shortcut? Clicking on the ribbon?

What do you mean you "cannot"... Excel gives you an error message? The option is grayed out in the ribbon? Excel lets you execute the command, but nothing happens?

Is there any code in the spreadsheet where you're trying to insert/delete?

 

[Michael M]

Also, check for Hidden or Very Hidden modules that may contain code !!