excel sheet

G

George A. Jululian

i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem
 
S

Sandy Mann

Check where XL *thinks* the last used cell is by using Ctrl + End on each
sheet of the larger Workbook and delete all the surplus Rows/Columns with
Edit > Delete ,(NOT just the Delete key), save the Workbook and see if it is
any smaller.

Failing the above cutting down the size, it may be that you have some
corruption in the Sheets/Workbook.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
G

George A. Jululian

Many thanks

still the same size

Regards

Sandy Mann said:
Check where XL *thinks* the last used cell is by using Ctrl + End on each
sheet of the larger Workbook and delete all the surplus Rows/Columns with
Edit > Delete ,(NOT just the Delete key), save the Workbook and see if it is
any smaller.

Failing the above cutting down the size, it may be that you have some
corruption in the Sheets/Workbook.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
G

George A. Jululian

if there any objects (pictures???) how can i find them

i cleared all the rows and columns
 
D

Dave Peterson

If they're visible, but to small to be noticed:

Do this on each sheet in the workbook:
Edit|goto|special|Objects

Then you can hit the delete key and delete all the selected objects.

If you get a message back that there are no objects, maybe they're not visible.
You can unhide them by using a small macro:

Option Explicit
Sub testme()
Dim shp As Shape
Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
For Each shp In wks.Shapes
shp.Visible = True
Next shp
Next wks
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top