+ Reply to Thread
Results 1 to 2 of 2

Cell values change randomly

  1. #1
    Registered User
    Join Date
    08-14-2014
    Location
    TX
    MS-Off Ver
    XP
    Posts
    5

    Cell values change randomly

    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.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Cell values change randomly

    Can you post the file?
    Remember you are unique, like everyone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Allocate Randomly based on Particular Cell Values
    By danweeks20 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2014, 06:57 PM
  2. How can I randomly reorder my values in my array?
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2008, 05:24 AM
  3. [SOLVED] In excel spreadsheet my comment boxes change sizes randomly why?
    By Scully in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-11-2005, 04:50 PM
  4. How do I randomly assign values in a grid?
    By Excel question in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2005, 08:05 PM
  5. [SOLVED] How do I change a cell's background color randomly, continually?
    By Jim Jones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2005, 09:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1