Preview

G

Guest

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.
 
D

Dave Peterson

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

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

Guest

Not in my summary tab.

Dave Peterson said:
There's an option under File|Properties|summary tab
to save preview picture

Maybe that one file didn't have this turned on???
Click to expand...
 
G

Gord Dibben

This would be done with the workbook opened and active.

File>Properties>Summary. 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Embedded Obects 1
Number of pages in worksheet doesn't match Print Preview pages 2
Print Preview is gone! 2
Print preview 10
Printing output not equal to preview in Excel 2007 1
Excel cuts off bottom of page in Print Preview 2
Word 2007 Document Preview 1

Top