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

Wednesday, April 6, 2011

Excel 2010 Insert PDF "Cannot start the source application for this object"

While attempting to insert a PDF file into an Excel file while using Excel 2010 (Insert tab, Object, Adobe Acrobat Document), one of my users was receiving the error: "Cannot start the source application for this object". In my scenario, we are running Office 2010 Standard & Adobe Reader X. From reports I have read, the same thing may happen with Excel 2007. Here is how to fix:

- Close Excel
- Open Adobe Reader X
- From the "Edit" menu, select "Preferences"
- Select "General" on left
- Uncheck "Enable Protected Mode at Startup"

You should now be able to insert PDF documents properly!

Thanks Kublai99!



What is Protected Mode?

Protected Mode is a new security feature for Adobe Reader X that protects users' applications and data by limiting what malicious files can do and access. Protected Mode is enabled by default and Adobe recommends that you leave it on for security reasons.