Forum Discussion
excessive rows and columns when another user updates
I send out excel sheets with 1,500 rows and six columns. I get it back with hundreds of thousands of extra rows and columns and vice versa. How can this be cleaned up? I have tried to copy out the relevant rows & columns into a new spreadsheet but then I can no longer cut/move/copy the existing data. This happens all the time.
I'm on windows 10 other users are not. I have tried the various methods available to clear but other than looping for an hour or more nothing happens.
Thanks in advance.
Stacy,
If available for your version of Excel you may use
Inquire is activated from File->Options->Add-ins->COM addins
Alternatively you may try to select all that empty rows/columns and Home->Clear->Clear All
Hi Stacy,
Are your extra rows/columns empty or they are with some unneeded data?
They are completely empty.
Thanks.Stacy,
If available for your version of Excel you may use
Inquire is activated from File->Options->Add-ins->COM addins
Alternatively you may try to select all that empty rows/columns and Home->Clear->Clear All
