Error: connection to another excel workbook (excel 2010)

fab54

New Member
Joined
Nov 14, 2008
Messages
30
Hello everyone,
I am having issues linking workbook B to my current workbook A.
I know it's easy to do and I have done it in the past like this:
Existing connections --> Browse for More --> Select file
Then I would get a window like this one (View image: excel select tab) where I could choose the tab I wanted to link. And that was it!
45iqfbuox


The problem is that now, after I select the file I have a "Data Link Properties" windows instead (View image: excel connection issue)

hmig68gkn


And I don't know what to do.I tried to click OK, to put my username and password but the connection does not appear in the list of connections.

Your help is highly appreciated.
Thanks in advance
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,214,641
Messages
6,120,693
Members
448,979
Latest member
DET4492

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top