File Preview Problem with Excel 2000 Template

pliskers

Active Member
Joined
Sep 26, 2002
Messages
441
Office Version
  1. 2016
Platform
  1. Windows
I just discovered the cause of a problem I noted with the inability to preview my files, even though they were saved as Excel 2000 worksheets with the Save Preview box checked in the Properties tab.

The problem appears to be due to the fact that my default workbook (Book.xlt) had been modified by me to include a bitmap image with my company's logo at the top of the page. Any files which I created using this template showed "no preview available", yet when I removed the bitmap image from my startup template, new files were displayed with previews.

I do also note, however, that if I insert the bitmap image into the file AFTER creating it from a template, the preview image does not update itself to include the bitmap. I am posting this message to bear out my thoughts and learn if previews cannot display bitmaps inserted into files.

Thanks for your feedback.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,541
Messages
5,832,334
Members
430,128
Latest member
ojl987

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top