Data not showing from Access linked work sheet

[shabbaranks]

Hi all,



Currently wrestling with a spread sheet (I'm no Excel expert by any means and I've inherited this job). If I manually filter the linked work sheet I can see all the data from the Access DB.

A second sheet using a pivot table is supposed to pull in the data from that first sheet - but its not, well not all of it anyway. How do I see where these data ranges are set in the pivot table (if that's how they work)? If Ive missed some vital info please let me know - as said Im certainly not an Excel expert - barely a novice

Thanks