Data feed problem after upgrading to windows 7 64-bit & excel 2010

graemeal

Active Member
Joined
May 17, 2007
Messages
316
Platform
  1. Windows
Hi,

I have just downloaded windows 7 64-bit and excel 2010 64-bit from XP and 2007 32-bit

My files are from excel 2007. Now in excel 2010 all of my RTD data links have #N/A in the cells. The data comes from a stock market charting program called phoenixai. I am assuming it is some security thing in windows 7 ???

Any assistance would be much appreciated. Thanks

=RTD("phoenixai.quotes","","LAST",INDIRECT(ADDRESS(ROW(),6)))
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
This may not be the cause of your problem but is worth while checking out.
Microsoft recommends using the 32-bit version of Office on a Windows 7 64 bit system:
http://office.microsoft.com/en-us/w...-version-of-microsoft-office-HA010369476.aspx
So you could try uninstalling the 64-bit version of Office 2010 and installing the 32-bit version?
I have seen this reported elsewhere, when checking before I upgraded.
 
Upvote 0

Forum statistics

Threads
1,214,383
Messages
6,119,196
Members
448,874
Latest member
Lancelots

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