Edit Color of Linked Excel Sheets?

[rfgetz]

Is the feature to edit the color of a linked Excel worksheet gone for good?
Our firm produces reports with both a dark and a light colored background...
thus the text needs to be black or white. Now we have to create a new
workbook, recolor all the fonts white and recolor all of the borders white...
not an easy task for the hundreds of pages a year we produce.

 

[BO]

rfgetz,

I'm not sure I can duplicate your situation. What version are you working in?

In PowerPoint 2003 and 2007 linked files open in native Excel by
right-clicking Linked Worksheet Object > Edit... or double clicking for me.

Cheers

 

[BO]

OK, I think I have a better understanding of what it is you're asking.
You're wanting to use PowerPoint as the engine to make the color changes for
Excel, correct?

Cheers

 

[Echo S]

Yeah, the recolor tool on the Picture toolbar is gone.

I know, I know. I used it all the time, too.

 

[BO]

Thank you! This function was news to me....and it looks incredibly useful
for 2003 I will pass this along to some folks here....

However, now that Office 2007 shares a common color library, is it quite as
necessary? Now that we can instantly reformat using combinations of themes,
styles, and templates (with which you could set up one for light and one for
dark), is it not a similarly simple transition as the Recolor tool in 2003?

Cheers
--
BO Haynes
Microsoft Master Instructor (MMI)

Yeah, the recolor tool on the Picture toolbar is gone.

I know, I know. I used it all the time, too.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

Is the feature to edit the color of a linked Excel worksheet gone for
good?
Our firm produces reports with both a dark and a light colored
background...
thus the text needs to be black or white. Now we have to create a new
workbook, recolor all the fonts white and recolor all of the borders
white...
not an easy task for the hundreds of pages a year we produce.

 

[Echo S]

It would be if users knew to use the same color shemes, apply themes, etc.

But I did like being able to recolor stuff on the fly. Quite handy,
especially for clipart.

There's a couple of screenshots and info about using the pix recolor on
charts here: http://www.echosvoice.com/charts.htm

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

Thank you! This function was news to me....and it looks incredibly useful
for 2003 I will pass this along to some folks here....

However, now that Office 2007 shares a common color library, is it quite
as
necessary? Now that we can instantly reformat using combinations of
themes,
styles, and templates (with which you could set up one for light and one
for
dark), is it not a similarly simple transition as the Recolor tool in
2003?

Cheers
--
BO Haynes
Microsoft Master Instructor (MMI)

Yeah, the recolor tool on the Picture toolbar is gone.

I know, I know. I used it all the time, too.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

Is the feature to edit the color of a linked Excel worksheet gone for
good?
Our firm produces reports with both a dark and a light colored
background...
thus the text needs to be black or white. Now we have to create a new
workbook, recolor all the fonts white and recolor all of the borders
white...
not an easy task for the hundreds of pages a year we produce.