Prev: headers frozen so that when you scroll they stay
Next: Fill handle increments year instead of day
From: iBob on 17 May 2010 16:06
I have 50 clients, each with an Accounts Recievable worksheet. Past due is
determined by using the =now and =today functions. This information is then
linked to Master sheet which displays all 50 clients at one time.

The problem is: When I open the Master sheet, the dates on the 50 'feeder'
sheets do not update the date. Only if those sheets are opened, does the date
update.

Is there a command to open and close those 50 sheets or a recalculate
command or perhaps, a macro is needed to open then close the 50 sheets.

Any suggestions?

I posted the same question about 3 hours ago but have'nt seen it appear
here, so if it does, please excuse the duplicate question (albeit, worded
differently)

Bob
From: RagDyer on 17 May 2010 19:56
Check your question in the "functions" group for my comment.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"iBob" <iBob(a)discussions.microsoft.com> wrote in message
news:3291F65A-C3AD-464E-9030-076BE3BC88B2(a)microsoft.com...
>I have 50 clients, each with an Accounts Recievable worksheet. Past due is
> determined by using the =now and =today functions. This information is
> then
> linked to Master sheet which displays all 50 clients at one time.
>
> The problem is: When I open the Master sheet, the dates on the 50
> 'feeder'
> sheets do not update the date. Only if those sheets are opened, does the
> date
> update.
>
> Is there a command to open and close those 50 sheets or a recalculate
> command or perhaps, a macro is needed to open then close the 50 sheets.
>
> Any suggestions?
>
> I posted the same question about 3 hours ago but have'nt seen it appear
> here, so if it does, please excuse the duplicate question (albeit, worded
> differently)
>
> Bob


 | 
Pages: 1
Prev: headers frozen so that when you scroll they stay
Next: Fill handle increments year instead of day