Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Outlook 2010 EXCEL (64 bit) problem

25 Apr 2010   #1

Linux CENTOS 7 / various Windows OS'es and servers
Outlook 2010 EXCEL (64 bit) problem

Hi there
This might be more related to IE8 rather than EXCEL but I find using EXCEL 2010 X-64 bit version with macros to dynamically create WEB QUERIES (retrieve external data from web sites), download into spread sheet and "Auto" update doesn't work properly.

This means some things like Stock exchange graphs on moving stocks or Horse racing statistics etc etc don't work properly.

I like trading options and need this type of functionality -- I'm NOT a professional "Day Trader" so I use my own data.

Since the web data is retrieved via some IE8 functionality I suspect it's probably becuase of the incompatability of EXCEL 2010 X-64 with IE8 (32 bit version).

No probs with Office / EXCEL 2010 32 bit version even on W7 X-64 ---I can test all these options with Virtual Machines -- you get a bit of grace before you have to "Activate" office 2010 although you have to enter the key when installing. Delaying activation allows testing both versions until extra keys are available on technet.

I NEED the Web query function to work ("Get EXTERNAL DATA") -- that is a HUGE showstopper.

I'm quite happy howeve to continue to use Office 2010 32 Bit -- the size of spreadsheets etc I use don't need the 64 bit version - but it would be nice to have 64 bit applications installed on W7 X-64.


My System SpecsSystem Spec
25 Apr 2010   #2

windows 7 Ultimate x64

I haven't tried to do this myself but I did find something in Office help you might find informative. I suspect that it may have something to do with Office Security and website trust settings.

The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
Important Connections to external data might be disabled on your computer. To connect to data when you open a workbook, you must enable data connections by using the Trust Center bar, or by putting the workbook in a trusted location.

For more information, see the articles Create, remove, or change a trusted location for your files, Add, remove, or view a trusted publisher, and View my options and settings in the Trust Center.
  1. On the Data tab, in the Get External Data group, click Existing Connections.

The Existing Connections dialog box appears.
  1. In the Show drop-down list, do one of the following:
    • To display all connections, click All Connections. This is selected by default.
    • To display only the recently used list of connections, click Connections in this Workbook.

      This list is created from connections that you have already defined, that you have created by using the Select Data Source dialog box of the Data Connection Wizard, or that you have previously selected as a connection from this dialog box.
    • To display only the connections that are available on your computer, click Connection files on this computer.

      This list is created from the My Data Sources folder that is usually stored in the My Documents folder on your computer.
    • To display only the connections that are available from a connection file that is accessible from the network, click Connection files on the Network.

      This list is created from an Excel Data Connection Library (DCL) on a Microsoft SharePoint Services site. A DCL is a document library in a SharePoint Services site that contains a collection of Office Data Connection (ODC) files (.odc). Typically, a DCL is set up by a site administrator, who can also configure the SharePoint site to display ODC files from this DCL in the External Connections dialog box. For more information, see SharePoint Services Central Administration Help.

      Tip If you do not see the connection that you want, you can create a connection. Click Browse for More, and then in the Select Data Source dialog box, click New Source to start the Data Connection Wizard so that you can select the data source that you want to connect to.

      Note If you choose a connection from the Connection files on the network or Connection files on this computer categories, the connection file is copied into the workbook as a new workbook connection, and is then used as the new connection information.
  1. Select the connection that you want, and then click Open.
  2. In the Import Data dialog box, under Select how you want to view this data in your workbook do one of the following:
Important The Select how you want to view this data in your workbook section and its options, as shown in the following list, are not available for text, Web Query, and XML data connections. If you are connecting to such data, skip to step 5.
  • To create a table for simple sorting and filtering, click Table.
  • To create a PivotTable report for summarizing large amounts of data by aggregating and subtotaling the data, click PivotTable Report.
  • To create a PivotTable report and PivotChart report for visually summarizing data, click PivotChart and PivotTable Report.
  • To store the selected connection in the workbook for later use, click Only Create Connection.
Use the Only Create Connection option to store the selected connection in the workbook for later use. For example, if you are connecting to an Online Analytical Processing (OLAP) cube data source and you intend to convert PivotTable cells to worksheet formulas by using the Convert to Formulas command (On the Options tab, in the Tools group, click OLAP tools), you can use this option because you don't need to save the PivotTable report.
  1. Under Where do you want to put the data?, do one of the following:
    • To place the PivotTable or PivotChart report in an existing worksheet, select Existing worksheet, and then type the address of the first cell in the range of cells where you want to locate the PivotTable report.
    • Alternatively, click Collapse Dialog to temporarily hide the dialog box, select the beginning cell on the worksheet, and then press Expand Dialog .
  2. To place the PivotTable report in a new worksheet starting at cell A1, click New worksheet.
  3. Optionally, you can change connection properties by clicking Properties, then making your changes in the Connection Properties, External Data Range, or XML Map Properties dialog boxes, and then clicking OK.
My System SpecsSystem Spec
26 Apr 2010   #3

Linux CENTOS 7 / various Windows OS'es and servers

Hi there
Thanks for the reply

For HOME use this type of security seems a bit over the top -- often I just want to look at and analyze data sources "Ad Hoc" - so continually adding and removing sites to "Trusted data sources" is just a BIG PAIN in the proverbial.

Sometimes we can just go totally over the top with this stuff -- I can understand a WORKPLACE restricting sites or being 100% sure of the integrity of the data source being connected to -- but for HOME users this is totally overblown.

There at least should be an option to turn the "trusted sites" option off. -- Now there MAY BE this option available but I haven't been able to find it yet.

This note from MS seems to imply we are stuck with it -- if this is true then that's a SHOWSTOPPER.

My System SpecsSystem Spec

30 Jul 2010   #4

Windows 7 64bit
Similar Problem

Did you ever figure out a fix for this problem?

I also trade options, and have been getting errors during the refreshment of my option chain data after installing 2010 64bit.

I would appreciate any help you are willing to give.

My System SpecsSystem Spec

 Outlook 2010 EXCEL (64 bit) problem

Thread Tools

Similar help and support threads
Thread Forum
How to export Outlook 2010 contacts to Excel?
I want to export all my contacts in Outlook 2010 to Excel. Suggestions? Why: I am fairly sure my outlook file is corrupt. I cannot see my contacts in category view as I did when I had the same program in WinXP (I upgraded to Win7.) After 8 months, the first category appeared in the Current...
Microsoft Office
Excel 2010 Problem?
Maybe not excel directly, maybe windows problem. (Dual monitors, right monitor #2 on right, where I have excel open) IF I am on a cell and want to format that cell, I right click and choose format. The format window will open under the cell that I want to format. The problem, if that cell is in...
Microsoft Office
Microsoft Office 2010 - Excel problem
Well not really a problem with Excel, more of a memory problem with me. A few years back (in '03 Office) I collapsed the Excel file by way of a phone conversation. And now I forget nor find the way to un-collapse and get my lines 1 thru 95 back. Although I have used info on lines 96 and on. Any...
Microsoft Office
Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003
Hi, If I upgrade only the Outlook part of my Office 2003 installation to Outlook 2010 will the "Ribbon" style menu of Outlook 2010 be installed in my remaining Office 2003 menus? I accept that at some point I will probably have to get to grips with the "Ribbon" style menus introduced...
Microsoft Office
Microsoft office 2010 excel and outlook
When I open excel, and go to the file tab, it hangs, and says it is trying to contact server1......which likely is my head office server, and I can't access that server...It also tries to access the server when I want to insert a do I stop these programs from trying to access the...
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 04:41.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App