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.

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 Haynes
Microsoft Master Instructor (MMI)



"rfgetz" wrote:

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

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


--
BO Haynes
Microsoft Master Instructor (MMI)



"rfgetz" wrote:

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

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


"rfgetz" <(E-Mail Removed)> wrote in message
news:E2199CE4-265A-4267-9AF3-(E-Mail Removed)...
> 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.

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)



"Echo S" wrote:

> 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
>
>
> "rfgetz" <(E-Mail Removed)> wrote in message
> news:E2199CE4-265A-4267-9AF3-(E-Mail Removed)...
> > 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.
>
>

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


"BO" <(E-Mail Removed)> wrote in message
news:0CC5476A-2318-44B9-BA5B-(E-Mail Removed)...
> 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)
>
>
>
> "Echo S" wrote:
>
>> 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
>>
>>
>> "rfgetz" <(E-Mail Removed)> wrote in message
>> news:E2199CE4-265A-4267-9AF3-(E-Mail Removed)...
>> > 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.
>>
>>