Software

Ask something
Discussion Locked

In Excel, Save Preview Picture may fail

0 helpful
2 replies

by dmichaels22 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

2 replies

by carquiza

Have you ever try to zoom to excel and print preview it again? Will that make any difference?
If it is hard to Save Preview Picture on Excel.
Make a printscreen capture of your document and
just crop it in Microsoft Photo Editor.
Press printscreen near F12, Open Microsoft Photo Editor, Pull-down menu Edit, Paste, then crop,
Saveas JPG file. Hope this helps.

by dmichaels22

Poster rated this answer.
Thank you but the semi-broken feature is supposed to provide a preview of the top left quadrant of the worksheet before you even open the file.

This discussion is closed to new replies.