Hello everyone.

I am not sure if there is a way to do this but here is my problem:

I have a pivot table. Once of the columns is based on the differenc
between the current date and a future date I used the formul
D5-TODAY() (D5 is the active cell that contains the future date). Fo
instance todays date is 11/22/05 and the future date in cell D5 i
11/27/05 the output is "5".

On the Pivot Table I am using the column with the diffence betwee
future date and current date to filter the results. This is calle
"Days Out". So a user can select 5 and see only the results that ar
five days out from the current date. This results displayed ar
determined by the future date in the pivot.

This works fine, but the user each day would have to refresh the tabl
to get it to refresh the table in order to date information that th
"Days Out" selection pulls from and filters.

Is there a way to write a script that would refresh the pivot tabl
when the user opens it so that don't have to do it manually?

Hope I explained this well enough. If not please let me know.

Thanks in advance for your help!!!:) :

--
jgp_
-----------------------------------------------------------------------
jgp_2's Profile: http://www.excelforum.com/member.php...fo&userid=2762
View this thread: http://www.excelforum.com/showthread.php?threadid=48737

jgp_2

Right-click on the Pivot Table and select Table Options. Enable
'Refresh on Open'. This will refresh the Pivot Table data everytime
the workbook is opened.

Does that help?

Gerry

Haukwa Wrote:
jgp_2

Right-click on the Pivot Table and select Table Options. Enable
'Refresh on Open'. This will refresh the Pivot Table data everytime
the workbook is opened.

Does that help?

Gerry

Thanks for your help, Gerry! I scanned over that option and didn't
notice it Must be thinking about the long weekend:)

Thanks again!!


--
jgp_2
------------------------------------------------------------------------
jgp_2's Profile: http://www.excelforum.com/member.php...o&userid=27624
View this thread: http://www.excelforum.com/showthread...hreadid=487377