Preview

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
There's an option under File|Properties|summary tab
to save preview picture

Maybe that one file didn't have this turned on???
 
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...
 
It's there in mine (xl2003 currently).

What version of excel are you using?
 
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
 
You must log in or register to reply here.

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
scale to page error in Excel 2007 3
I can not get a text box to print. 2
Why does my 100% Normal Page view not match Print Preview? 0
Why does text on page 3 not display in print preview and printing 1
Embedded Obects 1
cannot see the content of a file 1
Number of pages in worksheet doesn't match Print Preview pages 2

Back
Top