ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   importing links from access to excel to template (https://www.excelbanter.com/links-linking-excel/66727-importing-links-access-excel-template.html)

jwr

importing links from access to excel to template
 
I have a query in access 2003 that I am analyzing with the tools option in
excel. In excel I have created a template which is linked to the imported
excel file. Once the access is in excel, I am opening the template -- which
should bring over the information from the access to excel worksheet. The
information does come forward, but is not in the right location even though
the cells/rows and columns have not changed. Each time, I have to re-link
the information from the excel worksheet to the template.

Any suggestions?



jwrnana

importing links from access to excel to template
 
Does anyone have any suggestions??


"jwr" wrote in message
...
I have a query in access 2003 that I am analyzing with the tools option in
excel. In excel I have created a template which is linked to the imported
excel file. Once the access is in excel, I am opening the template --

which
should bring over the information from the access to excel worksheet. The
information does come forward, but is not in the right location even

though
the cells/rows and columns have not changed. Each time, I have to re-link
the information from the excel worksheet to the template.

Any suggestions?






All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com