Setting Pivot Rawsource...

pedie

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Hi, maybe kinda weird but let me try...Can vba set Pivot Rawsource to Access Database? that when the database is updated it reflects in Pivot in Excel?:)


Thanks in Advance!
 
Sort by date Sort by votes
Derek, once again thanks for helping out...
've gone through the link too...I have to try out each way and make it work...'ve never tried any of this...

Retriving the data to worksheet could be problem again if data is too hugh...pivot itself linked to database has hugh size..

But i'll try different ways out..

Thanks again Derek..'m kinda confused too now.. :)

Regards
Pedie

 
Upvote 0

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You must log in or register to reply here.

Similar threads

M
  • Question Question
Pivot Table Calculated Item Crashing Workbook
Replies
1
Views
395
cooleomter
C
T
  • Solved
Pivot table: issue with date column
Replies
4
Views
121
TKM623
T
I
  • Question Question
fixing number formats in pivot table
Replies
0
Views
208
INN
I
B
  • Solved
Error on method intersect
Replies
2
Views
117
Beneindias
B
N
  • Question Question
Column with Min/Average values at the end of Pivot Table
Replies
0
Views
161
Nurces
N

Forum statistics

Threads
1,224,557
Messages
6,179,502
Members
452,917
Latest member
MrsMSalt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top