auto scaling in excel

Posted by Cory on September 06, 2000 1:24 PM

I have a user that puts together about 60 charts in Excel and keeps getting memory errors, I heard if I turn off auto scaling this will help but I can't figure how to turn off this option. Will this help and can you assist with any other options. She is using a nt4 machine with office 97.

Posted by Michael Liu on September 06, 0100 4:42 PM

You need to add a key in the registry.
Using RegEdit, go to:
HKEY_CURRENT_USER/Software/Office/8.0/Excel/Microsoft Excel

Add a string key called:
AutoChartFontScaling

Set the value to: 0

Reboot and hopefully that fixes the problem.

Posted by Ivan Moala on September 06, 0100 9:32 PM

Here is a link that may also help with this;
Gives you other options

http://support.microsoft.com/support/kb/articles/Q168/6/50.ASP?LN=EN-US&SD=gn&FR=0

HTH

Ivan