tony@comperex.oz (Tony Williams) (11/01/90)
I have recently upgraded a Mac SE from 1MB to 2.5MB of RAM. Prior to the upgrade Excel documents opened relatively quick but now after the memory upgrade there is a noticable degradation in speed of opening. Also the operation of "deleting" a row or column takes an unbelievable amount of time. The problem occurs whether you run in Finder or Multifinder, whether RAM Cache is 32,64,128k or OFF, and changing the Application memory allocation up or down has no affect. It only appears to be doing it at v2.2 as I am running v1.5 on another Mac without any problem. There are no viri apparent, and the desktop has been rebuilt. Other applications like Word 4.0 and MacDraw and WordPerfect all appear to work perfectly normal. Dropping back to 1MB corrects the problem so it only appears to be at 2.2. There are no INITS running, just stocko standard Apple system. Any help would be greatfully appreciated. Not that it is related necessarily but on the same machine a 6-7 page spreadsheet got turned into a 367K Excel document by 2.2. This only happened once and appears to still be a good document very much inflated (bit like the OZ economy EH!). This only happened once and may or may not be related to the above problem. Thanks for any help in advance Tony Williams (Senior Systems Engineer) COMPEREX (AUSTRALIA) PTY LTD ---------------------------------------
trottiers@yvax.byu.edu (11/05/90)
TW> I have recently upgraded a Mac SE from 1MB to 2.5MB of RAM. TW> Prior to the upgrade Excel documents opened relatively quick but TW> now after the memory upgrade there is a noticable degradation in TW> speed of opening. Also the operation of "deleting" a row or column TW> takes an unbelievable amount of time. The problem occurs whether TW> you run in It looks to me like Excel is reading a much larger area as its "active" area than it needs to. Same thing happened to me once. At some point I positioned the cell pointer at a cell that was way off my spreadsheet and then Excel thought that it needed to keep track of everything in between. When deleting a cell it has to figure out what is in each of those extra cells (even if it's nothing) so that it can shift them. This looks to me to be the most likely problem. I'm not sure how to fix it other than selecting the active area of your worksheet, cutting it, and pasting to a new worksheet. This will mess up your column widths but everything else should cut and paste okay. Good luck. ********************************************************** * Steve Trottier * AOL: STrottier * * Brigham Young University * Sysop, Mainly Macintosh BBS * * trottiers@yvax.byu.edu * (801) 374-5438 * **********************************************************