Hi.
Users complain that sometimes they come across Excel files that are wildly slow when opening / scrolling. Along the way, it turned out that this is due to the presence of so-called hidden objects in these files. These objects need to be deleted.
I can open the file in Excel and use F5->select->objects to show these objects, and then delete them one by one. But if the file is large, it is VERY long.
I can open a file in the program via ODBC and delete objects via a command like sheets(1):drawind:delete(). However, such a file opens VERY slowly via ODBC.
Maybe someone has encountered something like this ?