Preview

T

tiler65

When I open a folder containing many work books/sheets I cannot view them in
the preview pane. In the pane it says preview not available.

How do I turn this on?

I have tried searching. Nothing found.

I have office 2002 sp3.
 
I

Ian

Open each file, go to File>Properties>Summary tab. Select Save preview
picture and resave the file.
 
T

tiler65

Yes I have tried that but I am having a problem with workbooks that are like
a template, I have an invoice workbook and each time I need a new invoice I
just amend the date, prices and invoice number and re save as the new invoice
number. Then I select save preview picture but when I come to open the
preview it says not available, it does work when starting a new workbook but
I do not want to do this. Do you understand me? Sorry if I am waffling. I
would prefer not to create a new workbook every invoice.

Thanks for reading.
 
G

Gord Dibben

This operation works for me.

Open Windows Explorer.

Drill down to the *.XLT file

Right-click and Open

It will open in Excel as *.XLT not as a new workbook.

File>Properties>General>Save Preview Picture.

Save and Close and do not create new record when asked.

All workbooks created from this template should then save with a preview.

Tested on Excel 2003.


Gord Dibben MS Excel MVP
 
Top