Prev: CAN I PERMANENTLY CHANGE COLORS IN THE 2003 EXCEL PALETTE
Next: Inserting automatic page breaks
From: p45cal on 13 May 2010 11:31

no trailing/leading spaces in the sheet name?



d
a
;
7
2
3
1
7
9

W
r
o
t
e
:


>
Thank you to all who responded.
> Yes, I do have a worksheet that is named "Daily Sworn Status', which is
in
> the same file.
> I also tried to change the formula by taking out Sum, and still I get
the
> same error#ref. And I also checked the spelling and it is correct (I
copied
> the name of the worksheet to avoid spelling mistake.)
>
> It is a mystery which took all my yesterday.
>
>
> "p45cal" wrote:
>
> >
> > probably a misspelling of the sheet name
> >
> >
> >
> da;722686 Wrote:
> > >
> > Hi
> > > When I use the following formula, I get #REF error.
> > > How can I fix it?
> > > Thank you
> > >
> > > =SUM('Daily Sworn Status'!M8)
> >
> >
> > --
> > p45cal
> >
> > *p45cal*
> >
------------------------------------------------------------------------
> > p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> > View this thread: 'Reference cell error - The Code Cage Forums'
(http://www.thecodecage.com/forumz/showthread.php?t=202394)
> >
> > 'Microsoft Office Help - Microsoft Office Discussion - Excel VBA
Programming - Access Programming' (http://www.thecodecage.com/forumz)
> >
> > .
> >


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394

http://www.thecodecage.com/forumz

From: Dave Peterson on 13 May 2010 11:45
Rename that sheet to: A
(Just a single letter)

Then check your formula. If the formula adjusted to the new name, then I don't
have a guess.

But my guess is that the formula stayed the same.

Now change your formula to:
='A'!M8

Did that evaluate correctly?

If it did, then change the name of the sending sheet back to what you want.

(I bet you'll find that if you look closely, there was a typo between the
formula and the sheetname.)

========
Another way to build that formula without doing any typing.

Select M8 on the sending sheet
Edit|copy
Then select the cell that should get the formula on the other sheet
Edit|paste special|click on Paste Link




da wrote:
> Thank you to all who responded.
> Yes, I do have a worksheet that is named "Daily Sworn Status', which is in
> the same file.
> I also tried to change the formula by taking out Sum, and still I get the
> same error#ref. And I also checked the spelling and it is correct (I copied
> the name of the worksheet to avoid spelling mistake.)
>
> It is a mystery which took all my yesterday.
>
>
> "p45cal" wrote:
>
>
>>probably a misspelling of the sheet name
>>
>>
>>
>
> da;722686 Wrote:
>
>>Hi
>>
>>>When I use the following formula, I get #REF error.
>>>How can I fix it?
>>>Thank you
>>>
>>>=SUM('Daily Sworn Status'!M8)
>>
>>
>>--
>>p45cal
>>
>>*p45cal*
>>------------------------------------------------------------------------
>>p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
>>View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394
>>
>>http://www.thecodecage.com/forumz
>>
>>.
>>

--

Dave Peterson
From: da on 13 May 2010 12:15
Thanks
I made sure there is no space or spelling mistake. I copied the worksheet
name. Still, same error.

"p45cal" wrote:

>
> no trailing/leading spaces in the sheet name?
>
>
>
da;723179 Wrote:
> >
> Thank you to all who responded.
> > Yes, I do have a worksheet that is named "Daily Sworn Status', which is
> in
> > the same file.
> > I also tried to change the formula by taking out Sum, and still I get
> the
> > same error#ref. And I also checked the spelling and it is correct (I
> copied
> > the name of the worksheet to avoid spelling mistake.)
> >
> > It is a mystery which took all my yesterday.
> >
> >
> > "p45cal" wrote:
> >
> > >
> > > probably a misspelling of the sheet name
> > >
> > >
> > >
> > da;722686 Wrote:
> > > >
> > > Hi
> > > > When I use the following formula, I get #REF error.
> > > > How can I fix it?
> > > > Thank you
> > > >
> > > > =SUM('Daily Sworn Status'!M8)
> > >
> > >
> > > --
> > > p45cal
> > >
> > > *p45cal*
> > >
> ------------------------------------------------------------------------
> > > p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> > > View this thread: 'Reference cell error - The Code Cage Forums'
> (http://www.thecodecage.com/forumz/showthread.php?t=202394)
> > >
> > > 'Microsoft Office Help - Microsoft Office Discussion - Excel VBA
> Programming - Access Programming' (http://www.thecodecage.com/forumz)
> > >
> > > .
> > >
>
>
> --
> p45cal
>
> *p45cal*
> ------------------------------------------------------------------------
> p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394
>
> http://www.thecodecage.com/forumz
>
> .
>
From: da on 13 May 2010 12:19
Thanks
You were right. There was a trailing space which I deleted and the formlua
worked.
Thank you

"p45cal" wrote:

>
> no trailing/leading spaces in the sheet name?
>
>
>
da;723179 Wrote:
> >
> Thank you to all who responded.
> > Yes, I do have a worksheet that is named "Daily Sworn Status', which is
> in
> > the same file.
> > I also tried to change the formula by taking out Sum, and still I get
> the
> > same error#ref. And I also checked the spelling and it is correct (I
> copied
> > the name of the worksheet to avoid spelling mistake.)
> >
> > It is a mystery which took all my yesterday.
> >
> >
> > "p45cal" wrote:
> >
> > >
> > > probably a misspelling of the sheet name
> > >
> > >
> > >
> > da;722686 Wrote:
> > > >
> > > Hi
> > > > When I use the following formula, I get #REF error.
> > > > How can I fix it?
> > > > Thank you
> > > >
> > > > =SUM('Daily Sworn Status'!M8)
> > >
> > >
> > > --
> > > p45cal
> > >
> > > *p45cal*
> > >
> ------------------------------------------------------------------------
> > > p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> > > View this thread: 'Reference cell error - The Code Cage Forums'
> (http://www.thecodecage.com/forumz/showthread.php?t=202394)
> > >
> > > 'Microsoft Office Help - Microsoft Office Discussion - Excel VBA
> Programming - Access Programming' (http://www.thecodecage.com/forumz)
> > >
> > > .
> > >
>
>
> --
> p45cal
>
> *p45cal*
> ------------------------------------------------------------------------
> p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394
>
> http://www.thecodecage.com/forumz
>
> .
>
From: da on 13 May 2010 17:21
Thank you. There was a trailing space in the worksheet name and that is why
formula gave an error.
It works now.
Thanks for your suggestion and help.

"Dave Peterson" wrote:

> Rename that sheet to: A
> (Just a single letter)
>
> Then check your formula. If the formula adjusted to the new name, then I don't
> have a guess.
>
> But my guess is that the formula stayed the same.
>
> Now change your formula to:
> ='A'!M8
>
> Did that evaluate correctly?
>
> If it did, then change the name of the sending sheet back to what you want.
>
> (I bet you'll find that if you look closely, there was a typo between the
> formula and the sheetname.)
>
> ========
> Another way to build that formula without doing any typing.
>
> Select M8 on the sending sheet
> Edit|copy
> Then select the cell that should get the formula on the other sheet
> Edit|paste special|click on Paste Link
>
>
>
>
> da wrote:
> > Thank you to all who responded.
> > Yes, I do have a worksheet that is named "Daily Sworn Status', which is in
> > the same file.
> > I also tried to change the formula by taking out Sum, and still I get the
> > same error#ref. And I also checked the spelling and it is correct (I copied
> > the name of the worksheet to avoid spelling mistake.)
> >
> > It is a mystery which took all my yesterday.
> >
> >
> > "p45cal" wrote:
> >
> >
> >>probably a misspelling of the sheet name
> >>
> >>
> >>
> >
> > da;722686 Wrote:
> >
> >>Hi
> >>
> >>>When I use the following formula, I get #REF error.
> >>>How can I fix it?
> >>>Thank you
> >>>
> >>>=SUM('Daily Sworn Status'!M8)
> >>
> >>
> >>--
> >>p45cal
> >>
> >>*p45cal*
> >>------------------------------------------------------------------------
> >>p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> >>View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202394
> >>
> >>http://www.thecodecage.com/forumz
> >>
> >>.
> >>
>
> --
>
> Dave Peterson
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: CAN I PERMANENTLY CHANGE COLORS IN THE 2003 EXCEL PALETTE
Next: Inserting automatic page breaks