Linking Data between Excel and PowerPoint

[Hibbs]

I have an Excel Spreadsheet that I am linking to PowerPoint using the
Paste-Special option on the Edit menu of PowerPoint. If I select the
"Linked" option the information looks fine when I first build the slide,
however when I "Update the Link", the font on the slide changes and the text
looks terrible.

Does anyone know how to hold the formating of the slide during an update?

 

[virtualSusie]

Hibbs:
Did you find a solution to your problem? The problem that you are having
sounds similar to the problem my boss says our client is having. I can't
replicate the problem, but I also don't think I am getting the whole story.
I have been reading a few things and have some ideas - but I just wanted to
know if you found a solution before I go on a wild goose chase.

susie

 

[Hibbs]

VirtualSusie

I have not resolved the problem yet and I really need to fine a solution.
If you can help, I would appreciate it.

It is an easy thing to replacate. Open a spreadsheet. Open a Powerpoint
with a blank or heading only layout. On the Excel side, mark out the area to
copy (suggest that you try it with a few rows and a couple of columns). Copy
the selection (Ctrl-Ins) and switch to the Powerpoint. From the toolbar:
Edit - Paste Special. Choose the Paste-Link option and select the Excel
object. press return to paste the cells into powerpoint.

You can resize and it looks good...until you "update the link". Highlight
the object, right click and choose "update link" and you will see the change.
Suddenly there are gridlines and a terrible looking font.

Help!

 

[Hibbs]

Steve,

I am working with Office 2003 - SP1.

Thanks for your help

 

[brian]

Hibbs,
I can't replicate it here on Office 2003 original CD

The gridlines do show up because you are using Ctl+Ins rather than
Ctl+C. Turn off the gridlines in Excel if you don't want gridlines in
PPT.

I first thought it had to do with the Zoom level setting in Excel
which has been an issue before but that does change my results any
more.

Any chance you aspect ratio is not the same for height and width?

Brian Reilly, PowerPoint MVP