Forum Home
Press F1
Thread ID: 1182	1999-04-04 05:57:00	Excel Out of Memory problem	Guest (0)	Press F1

Post ID	Timestamp	Content	User
1532	1999-04-04 05:57:00	Can anyone please help with the 'Not enough memory' problem I am having? I am using Office97, the total file size is only a little over 500KB, of which probably about a half is graphics, the rest being mostly formulae rather than data. It is primarily an engineering calculation sheet as opposed to a data referencing sheet. I have used quite a lot of conditional formatting and there is a lot of interaction of the formula. It became steadily worse as I added functions and now occurs when running a macro that preloads data. (maximum 'calculating' activity) often at the same place, where there is quite a lot of conditional formatting occurring. (cell colours, and borders changing) The first onset of the problem used to occur on a print or print preview command which I found I could work around by saving the loaded data, closing the file and reopening it, then printing. I have tried using it on several machines, a Pent90 and two Pent133's all running Win95 and surprise surprise, it is worse on the one with the most RAM (64M) when it occurs during a toggle down, after loading about a half of the entry data. There are five cross-referenced worksheets (performing related sub calculations) and I did get a small improvement when I set them all to the same zoom (100%) I posted my problem in an excel newsgroup but never got an answer, although I did see a reference to this problem, and labelled AGAIN so I presume it's not unique. Any help at all would be greatly appreciated, thanks.	Guest (0)
1