Friday, April 15, 2011

Embedded Excel Sheet Resizes After Editing in Powerpoint

One of my users was having an issue with Excel sheets embedded in Powerpoint resizing after editing. The sheet would shrink to almost 50% of it's original width. I was able to replicate the issue on my computer in Powerpoint 2003 & 2010 and struggled all day searching for a solution. Dragging, re-pasting, formatting the object and many other things we tried...failed. Finally a coworker passed me this link. 2 minutes later, all fixed.

Embedded Excel worksheets shrink when you edit them in PowerPoint

For a quick fix, paste this in notepad, save as a .reg and double-click:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options]
"QFE_NICE"=dword:00000001
"QFE_ONTARIO"=dword:00000001
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options]
"QFE_NICE"=dword:00000001
"QFE_ONTARIO"=dword:00000001
[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options]
"QFE_NICE"=dword:00000001
"QFE_ONTARIO"=dword:00000001

No comments: