Ask Your Question
2

seeking clarification of range name scope in Calc [closed]

asked 2012-03-20 16:02:58 +0200

JohnL gravatar image

updated 2013-02-03 09:45:07 +0200

qubit gravatar image

background ( all sheets in the same file ): one sheet named LECO - with a range name TotalShares defined with scope local one sheet named MDY - with a range name TotalShares defined with scope local one sheet named test - with a range name TotalShares defined with scope local one sheet named SummaryPositions

In a formula in the SummaryPositions sheet can I refer to the TotalShares range in the LECO sheet as LECO.TotalShares? When TotalShares was created in the LECO sheet it's scope was declared as local.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 16:12:43.477515

1 Answer

Sort by » oldest newest most voted
1

answered 2012-03-21 00:06:42 +0200

No you can't do that.

Local range names are only visible in the sheet where they are declared. You should think about using a global range name if you need it in more than one sheet, but keep in mind that local range names override global range names. So if you define RangeName1 in global scope and in Sheet1 you can use RangeName1 in every sheet but in Sheet1 it will refer to the local range name while in all other sheets it refers to the global range name.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-03-20 16:02:58 +0200

Seen: 642 times

Last updated: Mar 21 '12