General discussion
May 26, 2004 at 06:48 AM
dmichaels22

In Excel, Save Preview Picture may fail

by dmichaels22 . Updated 22 years, 2 months ago

Excel has a ?Save Preview Picture? feature which allows the user to view a small picture of the worksheet before opening the file.

Click File / Open and if you are in Preview mode you should see enough of the worksheet to be able to identify if it is the worksheet you are looking for.

I recently downloaded a few Excel templates from the Microsoft website and could not see a preview.

I?d click File/Properties and select the ?Save Preview Picture? box, saved the file again and still saw nothing.

The problem is that this feature fails if the width of column A is greater than 32. If it is 32 or less, the feature works fine.

Furthermore, if it is working fine and you change the width of column A to >32 it may appear to continue to work but the Preview you see will be the way the worksheet looked BEFORE you changed the width to >32.

I?ve tested this with Excel XP and 2000. Same bug in both.

This discussion is locked

All Comments