Work environment---------------------------
I have a presentation with a chart which is actually a PivotChart from excel
(embedded object)
therefore, if I double click on the chart, instead of taking me to
Powerpoint's Datasheet, it takes me to the embedded excel workbook.
In the embedded excel workbook I have 3 pages or tabs: 'Graph', 'PivotTable'
and 'DATA'
The Problem----------------------------
When opening the embedded excel workbook, if I switch through the tabs the
embedded window showing excel content resizes to it's original size.
So for example, if I go into the excel embedded object to modify data and
refresh the pivot table and graph, and then leave excel in order to go back
to my presentation, the graph or embedded object in my powerpoint
presentation resizes to it's original size and scale and I have to resize it
to the presenation's format again and again.
My solution--------------------------------
Initially I created a macro that I would run after I made a change, this
macro would simply resize the object back to the size I need. for it to show
correctly. My problem right now is that this file get's distributed and the
end users aren't necessarily Powerpoint or Macro savvy, but they DO go into
the object to look at the raw data, therefore the graph gets resized and the
presentation basically gets... messed up.
Is there any way to either:
1) Give the object a FIXED size, position, scale, etc... so that when
working with it, it will stay as originally positioned?
2) Write a subrouting that would resize the Object when the object changes?
This would basically run the same macro commands within a Object_Change
procedure.
Thank you!!
Regards,
Diego
|
Similar Threads
