Excel Pivot that we refresh

Mhypertext

Registered User.
Local time
Yesterday, 21:05
Joined
Dec 10, 2008
Messages
29
We want to import the excel doc in to access after the pivot table updates daily.

the problem is that at the top of the excel spread sheet we have all the filters instead of just the colum names when we hide them they show back up on the access import is there a way to get around this so that the filters are still on the excel sheet but those frist 4 rows of filters do show up when we import in to access?
 
Hi

I don't think that's possible as the fields are still there.

As a workaround, you could have a second worksheet in the same workbook that reads the original worksheet only from Row 5 down, not reading the top 4 rows.

So the formulas =FirstWorksheetA5 etc ... & copy that all over your second sheet.

Set it up so the import takes this second sheet as it will contain the updated pivots results excluding the pivot filter headings.

Not perfect but will work. hth
 

Users who are viewing this thread

Back
Top Bottom