Linked dynamic table from excel not working (1 Viewer)

setis

Registered User.
Local time
Today, 09:37
Joined
Sep 30, 2017
Messages
127
Hi all,

I have an dynamic excel that I exported from Microsoft CRM. The excel works perfectly, it gets updated and I managed to remove the warning message about the external connections.

When I link this table to access, there's no records there... I can see that all the lines are there, but empty.

Does anyone have an idea about what can be wrong?

Thanks!
 

Minty

AWF VIP
Local time
Today, 16:37
Joined
Jul 26, 2013
Messages
10,354
Re-link to it using the linked table manager, and tick the box that says prompt for a new location.

It sounds like you aren't connected to the right spreadsheet.
 

setis

Registered User.
Local time
Today, 09:37
Joined
Sep 30, 2017
Messages
127
Re-link to it using the linked table manager, and tick the box that says prompt for a new location.

It sounds like you aren't connected to the right spreadsheet.

Done and it's the same.

If the data is static it works perfectly. I've never made it to work linking dynamic tables :banghead:
 

Minty

AWF VIP
Local time
Today, 16:37
Joined
Jul 26, 2013
Messages
10,354
So are you saying there is a data connection in the spreadsheet to the CRM ?

If so why not connect directly to the CRM with Access ? If Excel can connect then so can Access.
 

setis

Registered User.
Local time
Today, 09:37
Joined
Sep 30, 2017
Messages
127
So are you saying there is a data connection in the spreadsheet to the CRM ?

If so why not connect directly to the CRM with Access ? If Excel can connect then so can Access.

Yes, the excel connects to the CRM.

I've check that connecting the Access directly with the CRM, it's possible but I would have to involve our IT department and let's say that that's always a bit complicated.

I would prefer to get this linked excel to work if possible.
 

Minty

AWF VIP
Local time
Today, 16:37
Joined
Jul 26, 2013
Messages
10,354
I'm not sure you can - certainly a quick Google hasn't brought anything up.

The connection would be the same between Access and the CRM and Excel and the CRM, So I'm not sure I understand the "difficulty"
 

Users who are viewing this thread

Top Bottom