Is it poss to resize sheet to "400 col by 2000 rows

keithkemble · Feb 16th, 2002, 04:54 PM

I would love to be able to resize one of my sheet to approx 400c x 2k rows.
If it is, how?, and would the code reside with in the file as I have to distribute file within the org.
kk

Paul B · Feb 16th, 2002, 05:08 PM

Sorry the Maximum worksheet size is 65,536 rows by 256 columns

Jack in the UK · Feb 17th, 2002, 03:17 AM

Hi--

Try transpose and so different way of working, i have been forced to do this before -

Else -- split over 2 or more sheets

HTH
Rdgs
==========
Jack

keithkemble · Feb 17th, 2002, 04:31 AM

Thanks JAck,
I do split over many sheets. It is that I am having hassle in trying to substitute a variable in a cell reference on a nother page.
Hopefully will post my problem later

Feb 18th, 2002, 12:13 AM

How hard have you tried to reduce the column count? Are a lot of borders turned on?

Is it possible that use of right-justify and left-justify could achieve psuedo-columns for you? How many of your columns end up being merged together?

keithkemble · Feb 18th, 2002, 03:17 AM

I cannot transpose as I require 20000 rows plus 400 cols. Others will be using the model and therefore simplicity is the key

I have already split the sheets as is the norm.
If any one find a code please advise.

Barrie Davidson · Feb 18th, 2002, 06:15 AM

Don't mean to rain on the Excel parade, but have you thought about using Access (or another database program)?

keithkemble · Feb 18th, 2002, 10:26 AM

Our IT dept do not want to pay for licences for 450 people.

Although we are 95 % Bill Gates dbases are frowned upon As we have our own IT dept. (Laugh I nearly died)

Jack in the UK · Feb 18th, 2002, 12:26 PM

Hi Keith --

I agree but did not want to say as Barrie has, your streatching Excel Shes lovley and sexy and all but suffers if you make her carry to much shopping.

She will be just fin if you split as you have but then its power of your PC..

Access has limits as well so its a trade of, i dont feel Access can allow the ciustom (whatever you like) as Excel will. VBA in Access is just as good, but i know no one that does this..

Good luck, pacic if Excel grinds to a halt.

TOP tip--- make regula back up in case it suffers heart attack!

HTH
Rdgs
==========
Jack

Feb 18th, 2002, 06:15 AM	#7
Barrie Davidson MrExcel MVP Join Date: Feb 2002 Location: Winnipeg Posts: 2,330	Don't mean to rain on the Excel parade, but have you thought about using Access (or another database program)? __________________ Barrie Davidson "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 16th, 2002, 04:54 PM	#1
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	I would love to be able to resize one of my sheet to approx 400c x 2k rows. If it is, how?, and would the code reside with in the file as I have to distribute file within the org. kk

Feb 16th, 2002, 05:08 PM	#2
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Sorry the Maximum worksheet size is 65,536 rows by 256 columns

Feb 17th, 2002, 03:17 AM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi-- Try transpose and so different way of working, i have been forced to do this before - Else -- split over 2 or more sheets HTH Rdgs ========== Jack

Feb 17th, 2002, 04:31 AM	#4
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	Thanks JAck, I do split over many sheets. It is that I am having hassle in trying to substitute a variable in a cell reference on a nother page. Hopefully will post my problem later

Feb 18th, 2002, 12:13 AM	#5
Guest Posts: n/a	How hard have you tried to reduce the column count? Are a lot of borders turned on? Is it possible that use of right-justify and left-justify could achieve psuedo-columns for you? How many of your columns end up being merged together?

Feb 18th, 2002, 03:17 AM	#6
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	I cannot transpose as I require 20000 rows plus 400 cols. Others will be using the model and therefore simplicity is the key I have already split the sheets as is the norm. If any one find a code please advise.

Feb 18th, 2002, 10:26 AM	#8
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	Our IT dept do not want to pay for licences for 450 people. Although we are 95 % Bill Gates dbases are frowned upon As we have our own IT dept. (Laugh I nearly died)

Feb 18th, 2002, 12:26 PM	#9
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi Keith -- I agree but did not want to say as Barrie has, your streatching Excel Shes lovley and sexy and all but suffers if you make her carry to much shopping. She will be just fin if you split as you have but then its power of your PC.. Access has limits as well so its a trade of, i dont feel Access can allow the ciustom (whatever you like) as Excel will. VBA in Access is just as good, but i know no one that does this.. Good luck, pacic if Excel grinds to a halt. TOP tip--- make regula back up in case it suffers heart attack! HTH Rdgs ========== Jack