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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,246
Messages
6,170,988
Members
452,373
Latest member
TimReeks

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