Forum Discussion
Stacy Vickery
Jul 23, 2018Copper Contributor
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 re...
- Jul 23, 2018
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
SergeiBaklan
Jul 23, 2018Diamond Contributor
Hi Stacy,
Are your extra rows/columns empty or they are with some unneeded data?
Stacy Vickery
Jul 23, 2018Copper Contributor
They are completely empty.
Thanks.
- SergeiBaklanJul 23, 2018Diamond Contributor
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
- Stacy VickeryJul 23, 2018Copper Contributor
I selected that, it doesn't show up, do I need to restart?
Thanks.
- Stacy VickeryJul 23, 2018Copper Contributor
I got it sorted now, thank you!!