Moving sheets

Phylis Sophical · May 11th, 2002, 12:35 PM

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 · May 11th, 2002, 12:36 PM

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

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-11 11:43 ]

Phylis Sophical · May 11th, 2002, 01:43 PM

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 · May 11th, 2002, 03:57 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 11th, 2002, 12:35 PM	#1
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	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.

May 11th, 2002, 12:36 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Won't hurt, move away eh (I'm inclined to say 'eh' as I was born in Ontario). _________________ Cheers, NateO [ This Message was edited by: NateO on 2002-05-11 11:43 ]

May 11th, 2002, 01:43 PM	#3
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	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.

May 11th, 2002, 03:57 PM	#4
Phylis Sophical New Member Join Date: Jan 2002 Location: Canada Posts: 42	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.