You could run a macro that looks for hidden shapes:

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

On Error Resume Next
For Each wks In ActiveWorkbook.Worksheets
For Each Shp In wks.Shapes
If Shp.Visible = msoFalse Then
MsgBox "Found one:" & vbLf & Shp.Name & vbLf & wks.Name
Shp.Visible = msoTrue
End If
Next Shp
Next wks
On Error GoTo 0
End Sub




Francis O wrote:

I have 2 EXCEL files with the same amount of data but have different sizes in
bytes.

One file size is 50KB the other, 1.5MB. What could be contributing to this
difference in size, and how do I find out the hidden objects that contribute
to this size of the file with 1.5MB?

--

Dave Peterson