Solve this mystery please...

pam53154

Board Regular
Joined
Mar 3, 2009
Messages
107
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.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
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?
 
Upvote 0
Also, check for Hidden or Very Hidden modules that may contain code !!
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,251
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top