worksheet size in bytes

T

Tamas Nagy

Hi Everybody,

is there any algorythm/function to know the size of given excel
worksheet in byte?

Tamas
 
J

Jim Rech

I think you'd have to save the worksheet in question as its own workbook.
While you could add up all the characters in all the cells that's only a
part of the picture given that many other things are part of the sheet,
formatting for instance.

--
Jim
in message |
| Hi Everybody,
|
| is there any algorythm/function to know the size of given excel
| worksheet in byte?
|
| Tamas
|
|
| --
| Tamas Nagy
| ------------------------------------------------------------------------
| Tamas Nagy's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=28000
| View this thread: http://www.excelforum.com/showthread.php?threadid=475020
|
 
T

Tamas Nagy

Thanks for the reply,

the problem is that I have a very large excel file (mainly because of
the formats), and I have to choose the biggest one, trying to reduce
them.
The file has more than 300 sheets, so the "manual" saving as a sole
sheet is not feasible. That is the reason why I have to get a
algorythmical solution in code (the savings requires lots of time).
 
Top