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
Stacy Vickery
Jul 23, 2018Copper Contributor
They are completely empty.
Thanks.
SergeiBaklan
Jul 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!!
- SergeiBaklanJul 23, 2018Diamond Contributor
For Excel 2016 it switches on/off on the fly. For previous versions I'm not sure.