Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden data?
I have a workbook with only a few cells occupied [50 rows x 20 columns
roughly], thought the workbook itself is more than 7 megs in size. There is obviously some hidden sheets / cells that I cannot find. How can I crack it to see what is inside? Can someone do it for me? Alan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden data?
Hi Alan
Try this http://www.contextures.com/xlfaqApp.html#Unused -- Regards Ron de Bruin http://www.rondebruin.nl "Alan" wrote in message ... I have a workbook with only a few cells occupied [50 rows x 20 columns roughly], thought the workbook itself is more than 7 megs in size. There is obviously some hidden sheets / cells that I cannot find. How can I crack it to see what is inside? Can someone do it for me? Alan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hidden data?
Alan
Not necessarily hidden sheets, although have you checked FormatSheet to see if the "unhide" is available? Could just be your apparent used range range is not what you think it is. Excel has a habit of including cells that once held data and/or formatting. See Debra Dalgleish's site for info on and fixes for this subject . http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben Excel MVP On Fri, 4 Jun 2004 15:36:00 -0700, "Alan" wrote: I have a workbook with only a few cells occupied [50 rows x 20 columns roughly], thought the workbook itself is more than 7 megs in size. There is obviously some hidden sheets / cells that I cannot find. How can I crack it to see what is inside? Can someone do it for me? Alan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
Hidden data - hidden chart | Charts and Charting in Excel | |||
HOW DO I HIDE DATA AND SHOW A PLUS SIGN THAT I HAVE HIDDEN DATA H. | Excel Discussion (Misc queries) | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |