imported tables distorted

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

Guest

Hi
I am making reports in Power Point and some of the data is in previous
reports and we are told to take to an old table and just copy and paste it.
This is where the problem arises, some of the tables no matter what tools I
use, will not adjust properly. The font will not take a specific size and not
look like it was just stretched out. I have cleared all formatting and still
no luck. I insert the slide from the previous report into the one that I am
working on.

Some of the tables from the old reports have been imported from another
program and the original files are not available to cleanly import the file.

I know I could redo the table but I am consistently told not to, I should be
able to use the existing tables. In a perfect world this would be great!

Suggestions would be appreciated, I may be missing the obvious.

System,
Windows XP
2003 Office

Thank you
MJ
 
I am not sure of the original source file. Currently the file is taken from
another Power Point file. I believe they originated from an Excel. The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power Point and not
keep the original file that was used and imported in.

MJ
 
After you paste the table into the other presentation, right-click it,
choose Format Object, and set to 100% x 100% on the size tab. It may overlap
your slide at this point, but just OK your way out anyway. Now, does the
text look right?

If so, then go back to the size tab and change the table size -- but change
it proportionately! You can do this by checking "lock aspect ratio" on the
size tab.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

MJ said:
I am not sure of the original source file. Currently the file is taken from
another Power Point file. I believe they originated from an Excel. The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power Point and not
keep the original file that was used and imported in.

MJ
Click to expand...
 
THANK YOU!!!!
It worked and has solved many problems.
MJ

Echo S said:
After you paste the table into the other presentation, right-click it,
choose Format Object, and set to 100% x 100% on the size tab. It may overlap
your slide at this point, but just OK your way out anyway. Now, does the
text look right?

If so, then go back to the size tab and change the table size -- but change
it proportionately! You can do this by checking "lock aspect ratio" on the
size tab.
Click to expand...
 
Ah, I'm very happy to hear that.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

MJ said:
THANK YOU!!!!
It worked and has solved many problems.
MJ

Echo S said:
After you paste the table into the other presentation, right-click it,
choose Format Object, and set to 100% x 100% on the size tab. It may overlap
your slide at this point, but just OK your way out anyway. Now, does the
text look right?

If so, then go back to the size tab and change the table size -- but change
it proportionately! You can do this by checking "lock aspect ratio" on the
size tab.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

MJ said:
I am not sure of the original source file. Currently the file is
Click to expand...
taken
from
another Power Point file. I believe they originated from an Excel. The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power Point and not
keep the original file that was used and imported in.

MJ

:

Can you tell me the source of your tables?
Click to expand...
Click to expand...
Click to expand...
 
so was her issue just a matter of X being different from Y? scaled
improportionately?

i have issues where my tables look fine until i try editing them, then when
i close them, they look terrible in ppt, borders show up, fonts are wrong,
all formatting is way off.

isnt this a fairly normal practice? shouldnt my excel file look corrent in
ppt, even after editing?

jeff

Echo S said:
Ah, I'm very happy to hear that.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

MJ said:
THANK YOU!!!!
It worked and has solved many problems.
MJ

Echo S said:
After you paste the table into the other presentation, right-click it,
choose Format Object, and set to 100% x 100% on the size tab. It may overlap
your slide at this point, but just OK your way out anyway. Now, does the
text look right?

If so, then go back to the size tab and change the table size -- but change
it proportionately! You can do this by checking "lock aspect ratio" on the
size tab.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I am not sure of the original source file. Currently the file is taken
from
another Power Point file. I believe they originated from an Excel. The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power Point and not
keep the original file that was used and imported in.

MJ

:

Can you tell me the source of your tables?
Click to expand...
Click to expand...
Click to expand...
 
Yes, I think the original poster's problem was the chart not being
proportional on the slide.

In your case, you might as well give it a shot; it definitely won't hurt.
Here's some additional info to bear in mind when working with charts:
http://www.echosvoice.com/charts.htm

Now, I have to admit, I've not seen borders show up out of the blue. I'm not
sure what the cause would be. And "fonts are wrong" and "all formatting is
way off" could be a whole bunch of stuff -- what exactly is going on with
the fonts and other formatting?

Brian Reilly always suggests putting your charts on chart sheets and then
inserting them into PPT. Hang on, lemme see if I can find his instrux. Ahh,
yeah, here it is: Problems with LINKED EXCEL CHARTS in PowerPoint
http://www.pptfaq.com/FAQ00067.htm You could also try Edit|Paste Special
and see if anything there works better for you.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


jeff topping said:
so was her issue just a matter of X being different from Y? scaled
improportionately?

i have issues where my tables look fine until i try editing them, then
when
i close them, they look terrible in ppt, borders show up, fonts are wrong,
all formatting is way off.

isnt this a fairly normal practice? shouldnt my excel file look corrent in
ppt, even after editing?

jeff

Echo S said:
Ah, I'm very happy to hear that.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

MJ said:
THANK YOU!!!!
It worked and has solved many problems.
MJ

:

After you paste the table into the other presentation, right-click
it,
choose Format Object, and set to 100% x 100% on the size tab. It may overlap
your slide at this point, but just OK your way out anyway. Now, does
the
text look right?

If so, then go back to the size tab and change the table size -- but change
it proportionately! You can do this by checking "lock aspect ratio"
on the
size tab.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I am not sure of the original source file. Currently the file is taken
from
another Power Point file. I believe they originated from an Excel.
The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power Point
and not
keep the original file that was used and imported in.

MJ

:

Can you tell me the source of your tables?
Click to expand...
Click to expand...
Click to expand...
 
thanks for the response echo.. these are charts actually they're xls tables,
rows and cells...

when edited cell spacing and row heights take on a mind of their own...
fonts go left aligned, etc. could the files be taking on properties/defaults
of the users application? as opposed to the creator's?

Echo S said:
Yes, I think the original poster's problem was the chart not being
proportional on the slide.

In your case, you might as well give it a shot; it definitely won't hurt.
Here's some additional info to bear in mind when working with charts:
http://www.echosvoice.com/charts.htm

Now, I have to admit, I've not seen borders show up out of the blue. I'm not
sure what the cause would be. And "fonts are wrong" and "all formatting is
way off" could be a whole bunch of stuff -- what exactly is going on with
the fonts and other formatting?

Brian Reilly always suggests putting your charts on chart sheets and then
inserting them into PPT. Hang on, lemme see if I can find his instrux. Ahh,
yeah, here it is: Problems with LINKED EXCEL CHARTS in PowerPoint
http://www.pptfaq.com/FAQ00067.htm You could also try Edit|Paste Special
and see if anything there works better for you.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


jeff topping said:
so was her issue just a matter of X being different from Y? scaled
improportionately?

i have issues where my tables look fine until i try editing them, then
when
i close them, they look terrible in ppt, borders show up, fonts are wrong,
all formatting is way off.

isnt this a fairly normal practice? shouldnt my excel file look corrent in
ppt, even after editing?

jeff

Echo S said:
Ah, I'm very happy to hear that.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

THANK YOU!!!!
It worked and has solved many problems.
MJ

:

After you paste the table into the other presentation, right-click
it,
choose Format Object, and set to 100% x 100% on the size tab. It may
overlap
your slide at this point, but just OK your way out anyway. Now, does
the
text look right?

If so, then go back to the size tab and change the table size -- but
change
it proportionately! You can do this by checking "lock aspect ratio"
on
the
size tab.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I am not sure of the original source file. Currently the file is
taken
from
another Power Point file. I believe they originated from an Excel.
The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power Point
and
not
keep the original file that was used and imported in.

MJ

:

Can you tell me the source of your tables?
Click to expand...
Click to expand...
Click to expand...
 
Ah, sorry. I missed where you said tables below -- I was obviously thinking
charts, although in retrospect, I've no idea why!

How are you pasting the cells into PPT? I'd use Edit|Paste Special and
choose Excel Object. Otherwise, you get a PowerPoint table by default, and
yes, these will take on various properties of the placeholder in the slide
master.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


jeff topping said:
thanks for the response echo.. these are charts actually they're xls
tables,
rows and cells...

when edited cell spacing and row heights take on a mind of their own...
fonts go left aligned, etc. could the files be taking on
properties/defaults
of the users application? as opposed to the creator's?

Echo S said:
Yes, I think the original poster's problem was the chart not being
proportional on the slide.

In your case, you might as well give it a shot; it definitely won't hurt.
Here's some additional info to bear in mind when working with charts:
http://www.echosvoice.com/charts.htm

Now, I have to admit, I've not seen borders show up out of the blue. I'm
not
sure what the cause would be. And "fonts are wrong" and "all formatting
is
way off" could be a whole bunch of stuff -- what exactly is going on with
the fonts and other formatting?

Brian Reilly always suggests putting your charts on chart sheets and then
inserting them into PPT. Hang on, lemme see if I can find his instrux.
Ahh,
yeah, here it is: Problems with LINKED EXCEL CHARTS in PowerPoint
http://www.pptfaq.com/FAQ00067.htm You could also try Edit|Paste Special
and see if anything there works better for you.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com


jeff topping said:
so was her issue just a matter of X being different from Y? scaled
improportionately?

i have issues where my tables look fine until i try editing them, then
when
i close them, they look terrible in ppt, borders show up, fonts are
wrong,
all formatting is way off.

isnt this a fairly normal practice? shouldnt my excel file look corrent
in
ppt, even after editing?

jeff

:

Ah, I'm very happy to hear that.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

THANK YOU!!!!
It worked and has solved many problems.
MJ

:

After you paste the table into the other presentation, right-click
it,
choose Format Object, and set to 100% x 100% on the size tab. It
may
overlap
your slide at this point, but just OK your way out anyway. Now,
does
the
text look right?

If so, then go back to the size tab and change the table size --
but
change
it proportionately! You can do this by checking "lock aspect
ratio"
on
the
size tab.

--
Echo [MS PPT MVP]
http://www.echosvoice.com

I am not sure of the original source file. Currently the file
is
taken
from
another Power Point file. I believe they originated from an
Excel.
The
original files are not available they were not saved separately.

It seems as if the past practices had been to save in Power
Point
and
not
keep the original file that was used and imported in.

MJ

:

Can you tell me the source of your tables?
Click to expand...
Click to expand...
Click to expand...
 
echo, that brings up a good question that i dont see a clear answer for. WHAT
technically is the difference between copying a table from excel and paste
special into ppt versus using insert object xls worksheet. i've tried both
and both dont like to be edited without reacting funny.

thanks
jeff
 
Back
Top