Linking sheets which must update the date first Excel 2007

I

iBob

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking sheets which must update the date first. 3
Text data -- linking Excel sheets 1
linking text strings to other cells 0
Charting macro for creating multiple charts on multiple sheets 0
linking to multiple workbooks 4
sheet update date 3
Using the IF and Sheets 0
Connecting a master sheet to other sheets within the same workbook 3

Top