Column Limit

A

al_b_cnu

Well-known Member

Joined

Jul 18, 2003

Messages

4,545

• Nov 17, 2003

• #2

Hi

'Fraid not.

could you reformat the data to be spread over >1 sheet?

HTH

Alan

 

Upvote 0

M

Myke

New Member

Joined

Jan 23, 2003

Messages

39

• Nov 17, 2003

• #3

Unfortunately because of the nature of the sheet, Columns from F-IV are all formulas in a calculation matrix (approximately 2.6Million formulas in total ) if I were to add another Sheet to the book then it would mean a LOT of recalculation to "point" to the new sheet. Thanks for your help though. I'll just have to tell our MD ray: (again) that if he needs the workbook to do more than it does, he'll have to pay for a proper database !!!

 

Upvote 0

A

al_b_cnu

Well-known Member

Joined

Jul 18, 2003

Messages

4,545

• Nov 17, 2003

• #4

Myke said:

Unfortunately because of the nature of the sheet, Columns from F-IV are all formulas in a calculation matrix (approximately 2.6Million formulas in total ) if I were to add another Sheet to the book then it would mean a LOT of recalculation to "point" to the new sheet. Thanks for your help though. I'll just have to tell our MD ray: (again) that if he needs the workbook to do more than it does, he'll have to pay for a proper database !!!

Click to expand...

Im no expert, but it sounds like you could easily export your s/sheet to Access

HTH

Alan

 

Upvote 0

B

bat17

Well-known Member

Joined

Aug 15, 2003

Messages

1,470

• Nov 17, 2003

• #5

I think that you could just cut your data from a-H and paste them to a new sheet. Excel should correct all of the formulas for you.

Peter

 

Upvote 0

M

Myke

New Member

Joined

Jan 23, 2003

Messages

39

• Nov 17, 2003

• #6

Actually, thats not a bad idea. I've been obsessing about columns f-IV and forgot all about moving the A-E columns!! Thanks!!

Oh... and yes. It would be great to put it in Access but our MD (whose knowledge of computers spans as far as "Why cant I get my email from my [UNCONNECTED TO THE NETWORK] laptop") decided that we didnt really need Access. Despite the fact that half ou business now relies of a spreadsheet which is so large it takes about 30 second to open!!!

Once again, thanks for the help guys. What would I do without ya !!! :wink:

 

Upvote 0

D

DThib

Active Member

Joined

Mar 19, 2010

Messages

464

Office Version

1. 365

Platform

1. Windows

• Apr 6, 2010

• #7

My formula is not that long. 46 out of 48 uses are good and return data. The 2 that do not are in the middle of the 48 and reference values above and below the problem cells. What gives?
Here are the formulas and ranges
=VLOOKUP("SA01a", $E$10:$P$165,10, TRUE) returns 0
=VLOOKUP("SA02a", $E$10:$P$165,10, TRUE) returns 0
=VLOOKUP("SA03a", $E$10:$P$165,10, TRUE) works fine

Can anyone solve it?

 

Upvote 0

Norie

Well-known Member

Joined

Apr 28, 2004

Messages

76,377

Office Version

1. 365

Platform

1. Windows

• Apr 6, 2010

• #8

Myke

You really need to get this out of Excel into another more application.

Perhaps if you pointed out to the MD that this might save money/time and wouldn't cost too much they might rethink things.

 

Upvote 0