Link problems after installing Office Service Pack 3

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

proefkonijn - 22 Nov 2007 15:09 GMT

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!

Reply to this Message

Bill Manville - 24 Nov 2007 08:44 GMT

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

Reply to this Message

proefkonijn - 26 Nov 2007 09:51 GMT

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...

> 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

Reply to this Message