Ok so here's the deal. I have a powerpoint presentation... well actuall
its just a flyer. In it I have 4 embedded Excel worksheets shown below
They are actually just a few cells of the worksheets refering to a
external sheet. The question is, is there away that i can open th
existing powerpoint file and by changing the value of one cell... mak
it change all of the "7"s to say... "8"s.

Embedded WS #1
='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$A$7

Embedded WS #2
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7

Embedded WS #3
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$7
='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$E7

Embedded WS #4
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$G$7
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$H$7

my thought on how to do this, was perhaps to put in one of the empt
cells in WS #1 the number 7. Then, call that value into the refernc
code. like this kinda...

=-'C:\PCS Connection\[Compan
Discounts.xls]Sheet1'!$B$((XWS#1-CELLVALUEX))

any ideas?

--
samccun
-----------------------------------------------------------------------
samccune's Profile: http://www.excelforum.com/member.php...fo&userid=1459
View this thread: http://www.excelforum.com/showthread.php?threadid=26340

The formula to do what you want is

=INDIRECT("'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$A$"&K1)

where you put the number 7 in cell K1.

On Fri, 24 Sep 2004 21:38:49 -0500, samccune
wrote:


Ok so here's the deal. I have a powerpoint presentation... well actually
its just a flyer. In it I have 4 embedded Excel worksheets shown below.
They are actually just a few cells of the worksheets refering to an
external sheet. The question is, is there away that i can open the
existing powerpoint file and by changing the value of one cell... make
it change all of the "7"s to say... "8"s.

Embedded WS #1
='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$A$7

Embedded WS #2
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7

Embedded WS #3
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$D$7
='C:\PCS Connection\[Company Discounts.xls]Sheet1'!$E7

Embedded WS #4
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$B$7
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$G$7
=-'C:\PCS Connection\[Company Discounts.xls]Sheet1'!$H$7

my thought on how to do this, was perhaps to put in one of the empty
cells in WS #1 the number 7. Then, call that value into the refernce
code. like this kinda...

=-'C:\PCS Connection\[Company
Discounts.xls]Sheet1'!$B$((XWS#1-CELLVALUEX))

any ideas??