Welcome to Personal Stock Monitor user forum. You must have an account to post to the forum. See the forum instructions page for some instructions on how to use the forum.
Subscribe to RSS Feed
Personal Stock Monitor Users Forum -> DDE is not working
Not logged in.
Advanced Search
Please login to post or reply.
2010-02-19 11:22:55
1 of 4
#1785
I switch to office 2007 and the links stop working. Using PSM 9.1.5
Posted by: Santiago
2010-02-19 13:46:28
2 of 4
#1790
in reply to #1785
Excel 2007 made some field names that we use into reserved words, so you have to update your links, changing all Price fields to Last, and all Yield fields to Yld.
Posted by: Anatoly
2010-03-12 16:11:17
3 of 4
#1859
in reply to #1790
I can see to the change in Excel 2007 but do I have to use options/preferences/data exchange custom syntax in PSM.

I have dragged and dropped many rows so is there an easy way to do this ?

Could you show a sample?.

Does the latest version of PSM already incorporate the Price and Yield name changes so enabling drag and drop?
Posted by: BA
2010-03-12 17:56:31
4 of 4
#1860
in reply to #1859
Yes, when you drag and drop from recent versions of the software, it will use the Last and Yld references automatically.

To change multiple cells in Excel, you should just be able to do search and replace from the Editing box. Replace !Price with !Last, and !Yield with !Yld.
Posted by: Anatoly