I'm creating a simple pivot table in Excel 2007 and it appears to be pulling data from my source sheet that I had deleted. I made sure that no rows/columns were hidden. Help
I'm creating a simple pivot table in Excel 2007 and it appears to be pulling data from my source sheet that I had deleted. I made sure that no rows/columns were hidden. Help
sounds as though you mean: http://www.contextures.com/xlPivot04.html
(see XL07 section)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That was perfect! I needed to select None from the data retetion drop down under PivotTable Options. Thanks so much for the quick help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks