I have a workbook with one worksheet which appears to be empty, however the
saved file is 3.5Mb. I am at a loss as to where all that content is?

I am not sure whether worksheets can be hidden, but you should be able
to find hidden rows and columns by clicking on the select all button
(the plain grey button at top left corner of the spreadsheet), then
right click and click on Unhide.

Alternatively, you could look for a break in the row or column sequence
- e.g., A, B, F, G, H or 1, 2, 3, 6, 7, 8.


--
tuph
------------------------------------------------------------------------
tuph's Profile: http://www.excelforum.com/member.php...o&userid=31390
View this thread: http://www.excelforum.com/showthread...hreadid=569271

you can see for hidden sheets and unhide them.
go to menu Format Sheet unhide

Alice Wrote:
I have a workbook with one worksheet which appears to be empty, however
the
saved file is 3.5Mb. I am at a loss as to where all that content is?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=569271

Do you have any pictures/shapes on the worksheet?
Edit|Goto|special|check objects

Open your workbook
hit alt-f11 to get to the VBE
hit ctrl-r to see the project explorer (like windows explorer)
Select your project in that window
hit the asterisk on the numeric keypad to expand everything.

Do you see more than one sheet under Microsoft Objects?

You should see all the sheets and ThisWorkbook.

Debra Dalgleish has some screen prints (for a different purpose), but you may
want to refer to them if you have trouble:

http://www.contextures.com/xlfaqMac.html#NoMacros



Alice wrote:

I have a workbook with one worksheet which appears to be empty, however the
saved file is 3.5Mb. I am at a loss as to where all that content is?

--

Dave Peterson

Thanks for your help. There were in fact empty objects on the worksheet.

Alice

"Dave Peterson" wrote:

Do you have any pictures/shapes on the worksheet?
Edit|Goto|special|check objects

Open your workbook
hit alt-f11 to get to the VBE
hit ctrl-r to see the project explorer (like windows explorer)
Select your project in that window
hit the asterisk on the numeric keypad to expand everything.

Do you see more than one sheet under Microsoft Objects?

You should see all the sheets and ThisWorkbook.

Debra Dalgleish has some screen prints (for a different purpose), but you may
want to refer to them if you have trouble:

http://www.contextures.com/xlfaqMac.html#NoMacros



Alice wrote:

I have a workbook with one worksheet which appears to be empty, however the
saved file is 3.5Mb. I am at a loss as to where all that content is?

--

Dave Peterson