Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable database connections
We have a large number of pivottables, all within the one
excel workbook using an ODBC connection to a SQL Server database. The SQL Server database has some complex queries in it to derive the data for the reports. They are essentially used as a reporting tool from the database. There are about 50 people using these reports on a daily basis. Until now we have simply been making changes to the reports on the live database as it has mostly been new developments or minor changes. However we are about to start making major changes which will take several days in development before moving to the production copy. What is the most effcient way of having a development SQL Server database and development Excel Spreadsheet and then moving them into production. My main problem is the connection between the pivottables and database as it takes forever to change all these connections. Is there a quick way to change the connections? If not what is the best workaround? Thanks Derek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivottable database connections
something like this should work - or at least give yousome ideas..
for each sh in thisworkbook.worksheet for each qt in sh.querytable msgbox qt.connectio qt.connection = "Your new connection string nex next |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel PivotTable for a huge DataBase from External Data | Excel Discussion (Misc queries) | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Addin for updating database by ammending pivottable | Excel Discussion (Misc queries) | |||
MS Excel 2000 - Change PivotTable DataSource (Access2000 database) | Excel Discussion (Misc queries) | |||
How do I set up a database with Excel with connections between se. | Excel Worksheet Functions |