Post #105,115
6/6/03 11:27:15 AM
|
Excel questions
I have a 2ghz cpu running at 1.8 490 megs ram winxp on a compaq laptop. I have a spreadsheet that I am running in share mode that consists of 60 columns and 1700 rows of textural data. The size of the sheet is 1200k I am only doing sorts, no math and it dogs the box to its knees, 100%cpu and swapping out to disk. I have 290 megs avsilable memory when I open the sheet. Any ideas?
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
"I hit him so hard in the head his dog shat a turd in the shape of Jesus" Leonard Pine
|
Post #105,122
6/6/03 12:05:50 PM
|
OS? Excel version? patch levels? Macros?
-----------------------------------------
[link|http://www.talion.com/questionw.html|?W]
Where were you in 72?
|
Post #105,124
6/6/03 12:12:15 PM
6/6/03 12:14:59 PM
|
here is what I can find (edited for rev level on OS)
excel 2002 10.216.2625
no macros
Microsoft XP professional 2002 dont know the patch level, info not on system display in the properties box of "my computer" ahh, found it winxp 5.1.2600 build 2600
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
"I hit him so hard in the head his dog shat a turd in the shape of Jesus" Leonard Pine
Edited by boxley
June 6, 2003, 12:14:59 PM EDT
|
Post #105,139
6/6/03 2:10:38 PM
|
I'd try the MS office service packs 1 and 2
You have to install them in order. I know there were some performance related issues these patches were supposed to fix. Don't know if it was specifically Excel related. :(
-----------------------------------------
[link|http://www.talion.com/questionw.html|?W]
Where were you in 72?
|
Post #105,145
6/6/03 2:21:36 PM
|
service packs? AAAARRRGGGHHH!!!!!
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
"I hit him so hard in the head his dog shat a turd in the shape of Jesus" Leonard Pine
|
Post #105,151
6/6/03 2:59:20 PM
|
ROFL
My sympathies Bill.
If you use a MS product, you install a MS patch. It's just that simple.
-----------------------------------------
[link|http://www.talion.com/questionw.html|?W]
Where were you in 72?
|
Post #105,148
6/6/03 2:27:41 PM
|
Do you *have to* run it "in share mode"?
If that's what it sounds like, then it sounds like a primary candidate for being your performance-killer.
Also, how many columns are you sorting on? If there's a lot of them, couldn't you do something else, to treat them all as one -- like, move those columns to the front (in the order you want to sort on them), export to, say, tab-delimited ASCII, run the command-line SORT utility, and finally re-import it to Excel?
And, the *first* thing to check: You *have* defined the whole data range as your "database" in Excel, haven't you?
HTH!
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
|
Post #105,153
6/6/03 3:02:52 PM
|
sort on only 2 fields
have to share or do all the freaking typeing myself. Dunnowhere to define whole datarange as database.
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
"I hit him so hard in the head his dog shat a turd in the shape of Jesus" Leonard Pine
|
Post #105,166
6/6/03 5:20:38 PM
|
So, WTF are you trying to *do*, really?
Da Ox: have to share or do all the freaking typeing myself. What, there's new typing going on all the time? And you're re-sorting like every other minute? The naive Excel-centric suggestion: Tell people to close it, then you UN-share, sort, and re-share it. It must be the share that does it -- I just built a test sheet (in Excel 2000) with 3000 rows and 80 columns, and that sorts in approximately no time at all, on my tired old Athlon 500/512 W2KPro box. The more relevant question: Is this really something one *should* use a *spreadsheet* for??? And, hey -- didn't you just install at least one Open Source RDBMS...? This thing seems to just *cry* for a client-server solution: Throw your data into a table, index it, let everybody access the DB, and you won't frigging *need* to re-sort all the time -- didn't that go out with bell-bottom jeans?!? That's what indexes are for! Dunnowhere to define whole datarange as database. Me neither -- can't find it in XL2K (have a stoopid Finnish-language copy here, that sucks). From what I can decipher of the help, seems it recognixes that automagically nowadays, so it's not necessary to define it any more. Must have been old superstition on my part...
[link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
|
Post #105,175
6/6/03 6:56:03 PM
|
on opensource DB's and what I am up to
I have 2, their datapumps choke and puke on WinXP Pro OBDC32 driver. Have an access licence coming monday as we have office standard, not pro. Once we import it into access I can do datacrap instead of spreadsheet crap. What I have is several hundred spreadsheets that have tiny pieces of the architecture that is built around 5 thousand plus machines. In a lotus table there is more spreadsheets. I need to build a repository, match serial numbers in the sheet to nodenames that I have to look up manually on a web query and when I get it all assembled, I will know what machine went where and how much load is on. This gives me the ability when an application support guy sticks his head in wanting more hardware I can prove he is fine and needs to use the 3 servers that are hosting his p0rn out of the closet instead of sucking money out of the company.
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
"I hit him so hard in the head his dog shat a turd in the shape of Jesus" Leonard Pine
|
