MSN Money Stock Quote Problem

M

Mike T

I created a spreadsheet in Excel XP for all my investments and used the MSN
Money Stock Quote add-in to update the daily activity values. I recently
upgraded to Excel 2007 and now can't get the data to appear in the cells.
Where I used to get a value, I now get #VALUE!. I have tried all the
recommendations in Microsofts Knowledge Database with no luck. Can anyone
please provide me with insight as to what has happened and a possible fix.
 
R

ryguy7272

Tools > Macro > Record New Macro (assign a shortcut key).
Data > Import External Date > New Web Query.
Navigate to your web site, import a sample of what you want to see in your
SS, and then go look at the code. It is very likely that the "WebTables"
have changed; the numbers of the tables are probably slightly different now
then they were when you last did the import.

Hope this helps.
Ryan---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top