Prev: Cells Are Not Updating
Next: List the UNIQUE certain fields from the database
From: Creating a Database in VWD on 23 Apr 2010 23:25
Hi,

I am copying my sheets and changing there names. For instance, I have sheets
in this order:

May 1 - Day and May 1 - Night. May 1 - Night has formula connecting it to
May 1 - Day, but when I try to update the formla, excel does not allow me.
instead, a window opens asking me to select a file I want to update.

Can anyone help me?
From: ozgrid.com on 23 Apr 2010 23:43
It means Excel does NOT recognize the Formula reference.



--
Regards
Dave Hawley
www.ozgrid.com
"Creating a Database in VWD"
<CreatingaDatabaseinVWD(a)discussions.microsoft.com> wrote in message
news:E2590B69-8FE5-4042-86CF-2D7AB8275FC7(a)microsoft.com...
> Hi,
>
> I am copying my sheets and changing there names. For instance, I have
> sheets
> in this order:
>
> May 1 - Day and May 1 - Night. May 1 - Night has formula connecting it to
> May 1 - Day, but when I try to update the formla, excel does not allow me.
> instead, a window opens asking me to select a file I want to update.
>
> Can anyone help me?

From: Dave Peterson on 24 Apr 2010 07:42
I'd guess you made a mistake in your typing of one of the sheet names.

You could temporarily change the name of 'May 1 - Day' to something like A (a
single character), then retype your formula using that temporary name.

And finally change the name back to what you want.



Creating a Database in VWD wrote:
>
> Hi,
>
> I am copying my sheets and changing there names. For instance, I have sheets
> in this order:
>
> May 1 - Day and May 1 - Night. May 1 - Night has formula connecting it to
> May 1 - Day, but when I try to update the formla, excel does not allow me.
> instead, a window opens asking me to select a file I want to update.
>
> Can anyone help me?

--

Dave Peterson
 | 
Pages: 1
Prev: Cells Are Not Updating
Next: List the UNIQUE certain fields from the database