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.

FilePropertiesGeneralSave 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

On Sat, 9 Dec 2006 04:21:00 -0800, tiler65
wrote:

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.

"Ian" wrote:

Open each file, go to FilePropertiesSummary tab. Select Save preview
picture and resave the file.

--
Ian
--
"tiler65" wrote in message
...
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.