This is a joke. How has this not be addressed? You can manually insert images into excel and it maintains the image file size perfectly but when you copy/paste it does crazy things.

7/7/2011 2:44:25 PM

Also I can't seem to upgrade to Office SP1. It came out June 29th and it didn't show up in my automatic updates so I downloaded it manually and when I try to install it, it says:

Quote :

"The expected version of the product was not found on the system"

7/7/2011 3:49:09 PM

I just installed SP1 today through windows update with no problems.

7/7/2011 4:42:20 PM

Ok yeah was able to upgrade to SP1 on my work computer. It fixes the image size bug. Check it out. Won't need to be downgrading after all.

7/7/2011 4:57:33 PM

Okay to answer the screenshot question.

Use the screen clipping tool in Excel.



Here's why.

When you do PrintScreen -> Paste, it pastes the RAW BITMAP into excel. Excel cannot change image formats internally. So you end up with a ginormous image.

If you use the screen clipping tool, it puts the screen clipping into a jpg container first, reducing the size by like 80%.

So, stop using the windows print screen button. Use the screen clipping feature in office or the windows Snipping Tool.

7/7/2011 4:58:52 PM

But see I use this screen capture software called Jing (automatically creates public URLs for viewing). When I save the png as a file it saves normal size. It's only when I copy and paste it into excel it blows up the file size. Excel must be converting the format. When I do the same thing in Excel 2007 it maintains the png file size.

Anyway SP1 fixed it so it must have been a bug.

7/7/2011 5:20:54 PM

100 million copies sold, not too shabby!

7/11/2011 1:52:56 PM