If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link problems after installing Office Service Pack 3
Linking to an Access query was no problem until Office SP2. since SP3 it is.
What do I do: - In access I put the query on the clipboard - In Excel paste the query with Paste Link. No problem until SP2: the formula bar shows name of database and query, since SP3 only the name of the database appears in the formula bar. The cells show all: #Name? Any clue? Thanks! |
#2
|
|||
|
|||
Link problems after installing Office Service Pack 3
I don't know the answer to your question, but I would always get data
from Access using Data Import External Data New Database Query Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Link problems after installing Office Service Pack 3
Hi Bill,
Thanks, I know that's the best way to do it. Still, the quick and dirty way of copy and paste link is fast and easy now and then. It is strange that a servicepack prevents this all... "Bill Manville" wrote: I don't know the answer to your question, but I would always get data from Access using Data Import External Data New Database Query Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|