Moving sheets

[Phylis Sophical]

I have a workbook with about 25 sheets. The first sheet is a Summary of all others and has many formulas that refer to each sheet. I would like to move the placement of one of the sheets to be the second one. Will this mess up any of the formulas in the Summary sheet?

I'm thinking of when you add a line or column in the wrong place, it will mess up formulas. I can't see this happening when moving the placement of sheets but just want to be sure.

 

[NateO]

Won't hurt, move away eh (I'm inclined to say 'eh' as I was born in Ontario).

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue">O</font></font></font>

This message was edited by NateO on 2002-05-11 11:43

 

[Phylis Sophical]

Our one exclusive identity isn't it. I ran off a copy of the summary sheet first and the figures all seem fine. Thanks for the confidence builder Nat. Small things mean alot eh.

 

[Phylis Sophical]

Oops! I did have to change one thing. My formula on the summary page was
=SUM('sheet1:sheet25'!C48)
In moving a sheet called misc to the front of the line, I had to change the beginning of the formula to:
=SUM('misc:sheet25'!C48)

So it does kind of act like adding a row/column in that it doesn't pick it up if it's at the very beginning or end of the formula.

Just thought I would add this in case another newbie tries it.