1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel 2010 array problem

Discussion in 'Business Applications' started by holymoly, Jul 12, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    I have a spreadsheet that each column splits out the numbers in one cell setup as an array, numbers separated by commas.

    So for example, an array cell has 2,345,789, 2839

    the four columns to the right show each number in each column.

    These columns have an elaborate formula but they all relate to the cell with the array, in the case $C.

    When I copied and pasted the formulas in the other columns in order to extract each number in the array, here is the issue I was confronted with. I changed the relative number so it would use the array cell; example $G was changed to $C the column the array is in.

    For some reason, columns I through M, after I save the spreadsheet or refresh it, always revert back to $G, while the other columns remain at $C.

    See the attached spreadsheet.
     

    Attached Files:

  2. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,916
    i just made the changes and saved the spreadssheet

    then opened again and hte changes remain OK

    what else are you doing - try saving with save as and change the name
     
  3. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    I tried saving under another name, and it seems OK. Interesting that some cells saved but others did not.
    I reopened file and it saved.


    Remember the file I gave you did not have an OBDC table connection that I need to refresh.

    Thanks
     
  4. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,916
    i suspect the ODBC only updated column C - is that correct ?

    what happens if you save with a different name and update odbc
     
  5. holymoly

    holymoly Thread Starter

    Joined:
    Jun 21, 2003
    Messages:
    635
    Originally the file saved only col F to H, did not for the next 4 and did for the next few.

    I seemed to resolve when saved under new name.
     
  6. etaf

    etaf Wayne Moderator

    Joined:
    Oct 2, 2003
    Messages:
    55,916
    (y) thanks for letting us know
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1060653