Excel sheet resizes itself when activated.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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.

--
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
 
Back
Top