Using Excel and Access XP and no programming in this procedure. I have a file of 20000 records with about 12 different column headings. I create a pivottable view and save as interactive DAP.. this produces the htm file and also a folder with the same name with the underlying data. This is...
I have created several Data Access Pages in combination with Pivottables... and all looks well until later in the day.. after several changes..
more than twice, the totals of my rows and columns changes from the accurate total of 22,141 to 10,000!
If I create another DAP and pivottable...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.