Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Excel 2010 array problem


(!)

holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
12-Jul-2012, 07:42 AM #1
Solved: Excel 2010 array problem
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
File Type: xlsx array.xlsx (10.1 KB, 22 views)
etaf's Avatar
etaf   (Wayne) etaf is online now
Computer Specs
Moderator with 52,950 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
12-Jul-2012, 08:57 AM #2
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
holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
12-Jul-2012, 09:57 AM #3
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
etaf's Avatar
etaf   (Wayne) etaf is online now
Computer Specs
Moderator with 52,950 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
12-Jul-2012, 10:28 AM #4
Quote:
Remember the file I gave you did not have an OBDC table connection that I need to refresh.
i suspect the ODBC only updated column C - is that correct ?

what happens if you save with a different name and update odbc
holymoly's Avatar
holymoly holymoly is offline
Member with 635 posts.
THREAD STARTER
 
Join Date: Jun 2003
Location: Mississauga, ON
Experience: Intermediate
12-Jul-2012, 03:14 PM #5
Quote:
Originally Posted by etaf View Post
i suspect the ODBC only updated column C - is that correct ?

what happens if you save with a different name and update odbc
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.
etaf's Avatar
etaf   (Wayne) etaf is online now
Computer Specs
Moderator with 52,950 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
12-Jul-2012, 03:20 PM #6
thanks for letting us know
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
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.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑