Hidden objects in Excel file

Hidden objects in Excel file

Postby Natter » Sat May 21, 2022 7:41 am

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 ?
Natter
 
Posts: 1204
Joined: Mon May 14, 2007 9:49 am

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Horizon and 44 guests