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)))
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
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.
 

graemeal

Active Member
Joined
May 17, 2007
Messages
316
Platform
  1. Windows
Thank you kindly. All OK now with the 32 bit Excel. Thanks again
 

Watch MrExcel Video

Forum statistics

Threads
1,122,961
Messages
5,599,061
Members
414,281
Latest member
Engjamal2021

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
Top