Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert query into excell sheet to update excell sheet and pivot table
Hi every one, This is my first post in this forum, hope I will get some reply, I have made pivot tabel just by copying the data in excll sheet and generate pivot table, is there any way that I could define sql quer in my excell shett so that I just run the query and it will update the excell sheet and pivot table or just pivot atbel by it self, or any other way to generate pivot table diynamicaly, my point is to creat a pivot table and give it to my boss, and it will be updateable by one or two click. Looking forward for oyu reply. Many thanks -- vbsolo ------------------------------------------------------------------------ vbsolo's Profile: http://www.excelforum.com/member.php...o&userid=26583 View this thread: http://www.excelforum.com/showthread...hreadid=398546 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
Make default insert sheet to have grid lines | New Users to Excel | |||
insert a bitmap to the background of a spread sheet | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |