This would be done with the workbook opened and active.

FilePropertiesSummary. Lower left is a checkbox for "Save Preview Picture".

Has been there since Excel 97 that I recall. Maybe earlier, but that's a
looooooonnnng time ago.


Gord Dibben MS Excel MVP


On Tue, 29 Aug 2006 09:18:02 -0700, sussertown
wrote:

Not in my summary tab.

"Dave Peterson" wrote:

There's an option under File|Properties|summary tab
to save preview picture

Maybe that one file didn't have this turned on???

sussertown wrote:

I noticed that when I perfrom an "open" from an excel document I have an
option for PREVIEW. All the files in one folder will preview except one. I
think I see the difference but no the cause. The good ones all have a
property that says "named rages, sheet1, print area. The two files that won't
preview don't have this. I don't see how to add it. I tried copying the
sheets and pasting them into a fresh document.

--

Dave Peterson