Using Excel with Access

[Jonathan]

I am working on a system which uses Excel to produce reports. When the user requests the report, a new excel workbook is created using a template, and the data is written in to the appropriate cells. Formatting is also carried out on the sheets, and the result is a fairly complex workbook with three near-identical sheets. This is done several times, to produce the same report for different clients, with each workbook being saved and closed after it is created.<br>
<br>
The problem is that while this works fine under Windows NT, it has a habit of hanging under Windows 95. It seems to work OK for reports with less data, but when there is a bit more to write it all grinds to a halt.<br>
<br>
Does anyone have any ideas on this?<br>
<br>
Thanks<br>
<br>
Jon

 

[DougP]

Yeah Office '97 was designed to run on NT, it is optimised for it.<br>
NT loves all the RAM you can give it. I suspect your NT box has a lot of RAM.<br>
<br>
how much RAM in on the '95 box<br>
and what speed is the CPU.Upgrading RAM first may help<br>
Otherwise if you have to upgrade too much in the '95 box consider getting another new NT machine.<br>
<br>
<br>

 

[Jonathan]

All our boxes have the same RAM (64Mb) and processor (PII, don't know about the speed). We really need to avoid the upgrade option if at all possible.<br>
<br>
Any other ideas?

 

[Dreamboat]

Can't say I agree with Doug and the NT issue. I'd like to see you make sure that if one is writing to a network drive, so is the other, and that the user has write rights to the folder, etc.; see if one person's Outlook is collecting journal entries and the other isn't; make sure the 95 isn't hanging because it has temp files on the C:\ drive (remove all *.tmp and ~*.* files off the entire C drive while its programs are closed), maybe it needs a scandisk and a defrag (after all, NT doesn't have as many problems in this area). Oh, yeah. And make sure the C:\temp or C:\windows\temp exists and isn't overcrowded. That's all I've got. I'd love to know whether it helped. Best of luck.