Excel sheet resizes itself when activated.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

T-Casey - 05 Nov 2007 21:50 GMT

Windows XP Pro
Office 2003
3.2 GHz pentium 4 with 1Gb memory

I am having an issue with a few of my presentations. I have multiple
reports that include both MSGraph objects and embedded Excel worksheets.
These objects are updated from VBA code in an excel workbook where the new
replacement data is stored.

My problem is that on some of my computers when the embedded Excel tables
are activated by either double click, menu - edit , menu -Open or VBA, the
table will snap to a different size. On a few this does not happen and they
will retain the required size . When they due resize, a CTRL-Z will return
the object to its appropriate size.

My questions are: Is there either an Excel or Powerpoint setting that is
controlling this issue? Is there a way to correct this?

I AssUMe this is a Microsoft feature.

Thanks in advance.

Signature

Tom Casey
Project Supervisor
sanofi-aventis

Reply to this Message

T-Casey - 07 Nov 2007 19:10 GMT

Thanks all,

After exhausting a lot of possible causes, memory/version differences etc..
This issue seems to be related to the screen resolution being used. When I
increased the screen resolution to 1280 x 1024 on all of the machines that
were misbehaving the reports would render correctly.

This seems to be a powerpoint specific issue. For when I copy & paste the
offending worksheet into a word document, it would no longer fight with me.

Maybe I should have known this?

Signature

Tom Casey
Project Supervisor
sanofi-aventis

> Windows XP Pro
> Office 2003
[quoted text clipped - 17 lines]
>
> Thanks in advance.

Reply to this Message

Echo S - 07 Nov 2007 22:36 GMT

How interesting.

I thought this issue was fixed as of PPT 2002 (aka PPT XP), and maintained
in PPT 2003, which is why I didn't mention this FAQ about combinations of
PPT, Windows and screen resolution.

http://www.pptfaq.com/FAQ00068.htm

I don't know if this helps explain it at all or not, though.

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
(New!) The PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/2qzlpl
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/index.html

> Thanks all,
>
[quoted text clipped - 35 lines]
>>
>> Thanks in advance.

Reply to this Message