Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default RTD Function Always Returns #N/A in Excel 2007

Hello,

I have several xls running on Excel 2003 that use the RTD function to
invoque an RTD server to collect data from an external source. However, I
just migrated to Excel 2007 and the RTD calls stopped working. They all
return #N/A and never update.

I wrote a simple RTD server (from the msdn pages) to test the RTD
functionality in Excel 2007 and under debugging I see that the RTD server
entry points are never called by Excel. I played around with all the new
security settings to the point where I just enabled all macros and everything
else, still with no result.

I know that RTD is not supported by Excel Services but I see no reason why
it would not work under Excel 2007.

Could anyone comment on this?

Thanks,

Jose
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Date Format Problem terry Excel Discussion (Misc queries) 0 November 25th 06 07:16 AM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) [email protected] Excel Worksheet Functions 0 September 5th 06 03:44 PM
Excel 2007 - Custom menus is missing! Søren Thade Petersen Excel Discussion (Misc queries) 3 July 11th 06 01:59 AM
FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC FRANCISCO PEREZ-LANDAETA Excel Worksheet Functions 0 July 6th 06 01:25 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"