Thanks to all that responded.

The only thing is that the refresh on open is done by selecting the
option within table options of the pivot table. I would assume the
suggestion given would mean I should deactivate the option and write
a macro that runs on open and then does both refresh and timestamp.
Nice one to cut my teeth on. I'll give it a go and let you know the
results.

For my first question in the newsgroup I've had great response and
help. Thanks so much.


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -