I must be tupid!
When I go to sheet 3 and put =Sum(Sheet2!E1:K1) a pop up comes up and
ask me to update the values for sheet 2. When I click OK it goes to
my folder work book is saved in! If I choose the wook sheet it shows
all the pages, I click on page 2 and it changes the value I just
entered in page 3 to "=SUM([Sheet2]Sheet1!E1:K1)"
What gives
--
firecord
------------------------------------------------------------------------
firecord's Profile:
http://www.excelforum.com/member.php...o&userid=24490
View this thread:
http://www.excelforum.com/showthread...hreadid=380884