I am wanting to set the parameters for a Crystal Report(10) so that it will be chosen from a list on an ASP page. I have looked at the "SimpleDiscreteParameters" page and modified it to work with my report. However, whenever I use a querystring to get the parameter value, it will only display...
After rebooting, any macro loads slowly - several minutes. Or any linking that is done to other sheets runs slow. Opening a regular spreadsheet does fine. Also when I run a custom form and input the information into the spreadsheet that takes about 30 seconds instead of being instantaneous...
Mark,
This slowdown occurs all the time after the crash. Even after rebooting and starting again. You don't mean there would still be an instance running after a reboot do you? I will check that to be sure. However, after rebooting the machine and starting excel, when I open the Excel...
Steve,
It was the service pack 1 and 2 that I upgraded with. After upgrading, I began having the problems. My excel now says it is 9.0.4402 SR1. Which is interesting because I have updated it with SP 2.
These updates are located on Microsoft Office web site.
George
I have timed this event and it takes 4 1/2 minutes to load the initial files and another 4.5 minutes to load the VLOOKUP connections. That means it takes almost 10 minutes to load the program. This is in contrast to about 5 seconds before the Office 2000 update.
George
Steve,
I am becoming very suspicious of the Office 2000 updates. I have two computers and three operating systems. I updated on my laptop using Windows XP and it runs slow. I updated on my desktop Windows 2000 OS and it runs slow. I have not updated on my XP boot on my desktop and it runs...
Steve,
I thought about that. I have Norton Antivirus and have tried disabling it and it still loads slow. It ran fine with Norton antivirus before I upgraded Office 2000. I don't know if upgrading Office 2000 had anything to do with the problem or not. I needed to upgrade because I was...
I am creating a VBA project in Excel for a company. It was working and loading fine and then suddenly whenever I tried to load the file or exit the file it was extremely slow (several minutes).
Is there a reason for this to happen.
The file is about 2.5 mb.
I have tried removing the...
I am creating a VBA project in Excel for a company. It was working and loading fine and then suddenly whenever I tried to load the file or exit the file it was extremely slow (several minutes).
Is there a reason for this to happen.
The file is about 2.5 mb.
I have tried removing the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.