Quote Originally Posted by Marc1919 View Post
On second note it has prevented my pivot table from automatically refreshing.

If you are still around or anyone here can help could you have a quick look maybe we can adjust something small. It seems the ScreenUpdating = False is what is stopping the pivot table from refreshing.
...


Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Also, please use code tags when posting code (see my foot note)