Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access to Excel-pivot, changing location of Access
Hi.
I've created pivottables based on data in Access, using the pivot wizard. I want to change the location of the Access database(db). I've already changed the db-location in the SQLcode in the query that gets the data to the pivot. Unfortunately when opening the xls-file, and refeshing the data, Excel still seeks for the 'original' database, which it cannot find anymore, since I moved it. Why doesn't it work when I've changed the location in the sql? Does Excel store the original location somewhere, and where is that? But the main question: What do I have to do to make this work, without having to built-up the Excelfile from scratch? Rishi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access to Excel-pivot, changing location of Access
Hi
Try downloading Ron Coderre's Addin - Pivot Play Plus. This will allow you to edit the links in Excel very easily http://www.contextures.com/PivotPlayPLUS.zip -- Regards Roger Govier "Rishi" wrote in message ... Hi. I've created pivottables based on data in Access, using the pivot wizard. I want to change the location of the Access database(db). I've already changed the db-location in the SQLcode in the query that gets the data to the pivot. Unfortunately when opening the xls-file, and refeshing the data, Excel still seeks for the 'original' database, which it cannot find anymore, since I moved it. Why doesn't it work when I've changed the location in the sql? Does Excel store the original location somewhere, and where is that? But the main question: What do I have to do to make this work, without having to built-up the Excelfile from scratch? Rishi __________ Information from ESET Smart Security, version of virus signature database 4244 (20090715) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4244 (20090715) __________ The message was checked by ESET Smart Security. http://www.eset.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access to Excel-pivot, changing location of Access
Hi Roger,
thanks for your reply. This add-in did the job. I'm just wondering: How would this be done without this add-in? Rishi "Roger Govier" wrote: Hi Try downloading Ron Coderre's Addin - Pivot Play Plus. This will allow you to edit the links in Excel very easily http://www.contextures.com/PivotPlayPLUS.zip -- Regards Roger Govier "Rishi" wrote in message ... Hi. I've created pivottables based on data in Access, using the pivot wizard. I want to change the location of the Access database(db). I've already changed the db-location in the SQLcode in the query that gets the data to the pivot. Unfortunately when opening the xls-file, and refeshing the data, Excel still seeks for the 'original' database, which it cannot find anymore, since I moved it. Why doesn't it work when I've changed the location in the sql? Does Excel store the original location somewhere, and where is that? But the main question: What do I have to do to make this work, without having to built-up the Excelfile from scratch? Rishi __________ Information from ESET Smart Security, version of virus signature database 4244 (20090715) __________ The message was checked by ESET Smart Security. http://www.eset.com __________ Information from ESET Smart Security, version of virus signature database 4244 (20090715) __________ The message was checked by ESET Smart Security. http://www.eset.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trust Access to Visual Basic Project - Access to Excel and back | Excel Programming | |||
How do I access the access data via Excel 2002 with auto update ? | Excel Programming | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Changing an Access Query in Excel | Excel Discussion (Misc queries) | |||
Excel - MS Query - changing location of Access data source | Excel Programming |