ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HELP pleeease - remove hidden data (https://www.excelbanter.com/excel-discussion-misc-queries/71735-help-pleeease-remove-hidden-data.html)

martyzeman

HELP pleeease - remove hidden data
 

Hi,

I have following problem: when I write for example something to cell
"IV65336" and then I remove it - the size of file is much bigger and
sort is much slowly,... Can anybody help me remove this hidden data? I
wan't use the rhtool from Microsoft, because then show me excel that
the file should be read-only and absurdity messages. Technical support
of Microsoft in CZ is terrible!!!!:mad: :mad: :mad:

Pleeease help me.

Marty


--
martyzeman
------------------------------------------------------------------------
martyzeman's Profile: http://www.excelforum.com/member.php...o&userid=31568
View this thread: http://www.excelforum.com/showthread...hreadid=512633


Norman Jones

HELP pleeease - remove hidden data
 
Hi Marty,

See Debra Dalgleish's suggestions for reserrting the used range at:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



"martyzeman" wrote
in message ...

Hi,

I have following problem: when I write for example something to cell
"IV65336" and then I remove it - the size of file is much bigger and
sort is much slowly,... Can anybody help me remove this hidden data? I
wan't use the rhtool from Microsoft, because then show me excel that
the file should be read-only and absurdity messages. Technical support
of Microsoft in CZ is terrible!!!!:mad: :mad: :mad:

Pleeease help me.

Marty


--
martyzeman
------------------------------------------------------------------------
martyzeman's Profile:
http://www.excelforum.com/member.php...o&userid=31568
View this thread: http://www.excelforum.com/showthread...hreadid=512633




martyzeman

HELP pleeease - remove hidden data
 

Hi Norman,

Thank You for Your help. It's OK now.:) :)

Marty


--
martyzeman
------------------------------------------------------------------------
martyzeman's Profile: http://www.excelforum.com/member.php...o&userid=31568
View this thread: http://www.excelforum.com/showthread...hreadid=512633



All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com