I don't know what you mean by "the information is not shared with the
other sheets." What's on the other sheets?

What exactly happens when you refresh the pivot table?
What results do you expect to see, that you don't see?

LYNDE wrote:
I HAVE TRIED ALL OF THE SUGGESTIONS IN MICROSOFT BUT NOTHING WORKS. IT SEEMS
TO GO THRU IT'S CYCLE BUT THE INFORMATION IS NOT SHARED WITH THE OTHER SHEETS.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html