I created a multipage spreadsheet to track stocks. Two pages import quotes from Microsoft automatically about every 10 minutes. The main page organizes these stock quotes next to the symbols. Stock price, $ change, then % price change. For example, for symbol INTC,
PRICE cell is =Quotes!D120.
$ change is =Quotes!J120
% change is =Quotes!I120
Now all of a sudden, during a random refresh, EXCEL IS CHANGING THE VALUES from D120 to AB120. J120 to AG120. I120 to AH120. That was after fixing it earlier today. Earlier today it randomly changed those values to something else. Like A, T, and V substitutes for the proper fields. This is happening to about 10 stocks in a row, but I think I saw it on a couple others earlier. It is as if someone is changing these fields (but they aren't!) The fields on the pages being pulled from are staying the same. I don't touch them. BIZARRO WORLD!
HELP!
Using Office (Exel) XP on a Windows 7 PRO 64-bit OS.
Bookmarks