i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

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


Replace @mailinator.com with @tiscali.co.uk


"George A. Jululian" wrote in
message ...
i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

Many thanks

still the same size

Regards

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"George A. Jululian" wrote in
message ...
i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

Do you have any objects (pictures???) in the larger workbook?



George A. Jululian wrote:

i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

--

Dave Peterson

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

i cleared all the rows and columns

"Dave Peterson" wrote:

Do you have any objects (pictures???) in the larger workbook?



George A. Jululian wrote:

i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

--

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

George A. Jululian wrote:

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

i cleared all the rows and columns

"Dave Peterson" wrote:

Do you have any objects (pictures???) in the larger workbook?



George A. Jululian wrote:

i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

--

Dave Peterson


--

Dave Peterson

Thank you very much for your help and support

Regards



"Dave Peterson" wrote:

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

George A. Jululian wrote:

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

i cleared all the rows and columns

"Dave Peterson" wrote:

Do you have any objects (pictures???) in the larger workbook?



George A. Jululian wrote:

i have two workbook both of them contain the same letter

on 175KB and the other 1082KB

how can I solve the problem

--

Dave Peterson


--

Dave Peterson