I need help fast.............

[Lisa]

I created a work book with several sheets on an obsolete
system at work (excel)I put in functions
(average,mas,if...then,etc.) and tied them all together
(sheet1,sheet 2,etc...)at the end my boss "renamed" the
sheets as week 1,week 2 etc) did it blow my functions in
the cells away and do I have to go back in and incorporate
the new names of the sheets in the functions?
Pleas someone help me ......
THANKS,
Lisa

 

[Anne Troy]

Probably not, Lisa. Depends on the *obselete* version...
I know that 97 and up will auto-change your formulas, as long as they're not
user-defined functions hard-coded to cells using VBA.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com

 

[Frank Kabel]

Hi
should be no problem renaming the worksheetnames (besides some
exceptions like using INDIRECT). but normally Excel will change the
sheet reference for you