Get External Data

2

22strider

Active Member
Joined
Jun 11, 2007
Messages
311
Hi

Could anyone tell how to enalble "Get External Data" section under "Data" menu? I am using Excel 2007 and want to connect two spreadsheets. But for some reason this section is grayed out.

Thanks
Rajesh
 

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,)
You must log in or register to reply here.

Similar threads

D
  • Question
Newbie to data connections...
Replies
1
Views
201
Kerryx
K
A
  • Question
Slow Excel browsing in Editing mode, but Protected View seems to be fast
Replies
1
Views
284
anonymoussy
A
A
  • Question
Insert row takes much time
Replies
4
Views
315
kvsrinivasamurthy
K
S
  • Question
Edit Connections - no external link
Replies
1
Views
363
Fluff
Fluff
B
  • Question
How do I change the PivotTable data sourced by external connection to a table in the workbook?
Replies
0
Views
761
bigsim
B

Forum statistics

Threads
1,215,978
Messages
6,128,053
Members
449,416
Latest member
SHIVANISHARMA1711

Share this page

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