Hi all, I hope someone here can shed some light on a problem I've been having. It's a problem with my PC at work, running Office 2003 on Windows XP Professional. My PC and peripherals are Dell. I have already had our IT team looking at it, but they couldn't find the problem nor the solution, so I know it might be a long shot! This only happens in Excel - not in the bespoke software I use at work, nor the browser, or Word (I don't use any other Office programs so can't comment on those). When I am in Excel, I can scroll using the wheel as normal without problems. However, if I click the wheel (to enable faster scrolling) and then move the mouse to try and scroll over a large number of cells, my computer completely shuts down after a couple of seconds with no warning.
Work is lost and I have to reboot from scratch. It is almost as if the mouse wheel button is a shortcut to shut down, except IT here have checked that and it isn't the case - and also, it only happens in Excel! If anyone can suggest anything, I would be really grateful. Even after several months I still occastionally forget I can't click the wheel and I end up losing work.
This Excel tutorial explains how to freeze panes to keep the first column visible when scrolling in Excel 2011 for Mac (with screenshots and step-by-step instructions). In Microsoft Excel 2011 for Mac, I have a spreadsheet and I need to freeze the first column.
Please don't hesitate to ask if you need any more info to help in finding a solution Thanks!! From: MS Excel for Windows - Mouse Settings Customize Windows START, Settings, Control Panel - Mouse Left Button: Left-click (global/default) Right Button: Right-click (global/default) Wheel Button: Enter (global.override.) Large Thumb Button: Back (global/default) Small Thumb Button: Forward (global/default) Excel: Tools-Options-General-'zoom on roll with intellimouse keep this off or you won't be able to use mouse for a vertical scrolling, you can still use Ctrl+wheel to zoom in/out. VBE problems with scrolling: make sure you do not have exceptions in Control Panel, Mouse, General, Advanced or for some older drivers there is a tab near the end or from Wheel tab, Wheel trouble shooter, Advanced button remove any added override that does not respond to scrolling or for some make sure Use MS Office Compatible scroll is checked (even if available may not be needed) If still not working see this thread.
I never had any problems with Excel until I got a new Macbook Pro over the holidays (Jan 2013) with Mountain Lion pre-installed. Then Excel just began running incredibly slow as everyone here has experienced. It definitely seems to be a Font related problem, and since I could create a new user on my machine and Excel ran fine from that login, I did some detective work with fonts and worked out a way to strip down fonts in my regular account log in. Keep in mind that I don't do any work with fonts really, so it didn't matter to me if I lost any special fonts because I never actively installed any.just accumulated alot of extra fonts over the years from various apps and rolling my data over through multiple Macbook incarnations. This is how I got everything running at normal speed again. 1) Open Font Book Application 2) Under EDIT, select LOOK FOR ENABLED DUPLICATES 3) Automatically resolve any duplicates found 4) Select all fonts, then under FILE select VALIDATE FONT 5) Remove all fonts showing any type of error or warning.
Some will be system fonts and will require you to enter your passwordgo ahead and do itget them all out of your system. 6) Under FILE, select RESTORE STANDARD FONTS. This will pull out everything except standard fonts. You will probably get a message saying that some of the standard fonts are missing and asking you to restore them by reinstalling the operating systemdon't bother doing it though. The missing fonts are likely ones that got tossed out when you VALIDATED FONT and threw out the ones causing warnings/errors.
7) Open your OS Library and look for the FONT folder. You should also see FONTS (REMOVED) and FONTS DISABLED. Open the FONTS (REMOVED) folder and find the MICROSOFT folder. Drag this back into your FONTS folderit will proceed to copy over. A copy will remain in FONTS (REMOVED) and a new copy will be formed in FONTS. 8) Finally, for good measure use Disk Utility to repair disk permissions and then restart. This processed worked on my brand new Macbook Pro running Mountain Lion, as well as my wife's 2 year old Macbook Pro running Mountain Lion.
I spent 3 hours searching forums and testing things yesterday and this finally worked.hopefully it can save others from wasting as much time as I was forced to. I don't know if this will be of any help to anyone but thought I'd offer up our experience.
We were running Mac OS X Lion and the latest version of Office and had problems with Excel being horribly slow as well. I did some testing and noticed that when I turned off Suitcase Font Management that Excel ran fine.
I assumed it was a confict with Suitcase so I contacted Extensis to see if they were aware of any issues with their product and Office. They did some testing on their end and could also reproduce the issue, but it turned out that it was not a conflict with Suitcase, but rather the fact that Office expects at least two of the Office fonts (Arial.ttf and Calibri.ttf) to be active. Since we use many fonts in our graphics businees we try to streamline our basic fonts and only have those active that we use on a regular basis so we had removed all Office fonts and did not have the expected fonts loaded. Once I added them back into our active fonts Office sped up quite nicely, No more slow copy, paste or print. So you may want to check out your fonts to make sure these two are active on your system. Since we use Suitcase for font management I simply loaded them in with our standard font set through Suitcase, but if you don't use Suitcase make sure they are in one of the appropirate Mac OS font folders so that they load at startup then reboot your computer and give Office another try. Hope this is helpful to someone.
![For For](http://i1.ytimg.com/vi/kiOYTpGHyac/maxresdefault.jpg)
Hoho this made me laugh. There isn't a 'Microsoft Knows Best' switch as such, what I meant by that was all the Preferences that do things automatically. These can be a huge drain on resource, because the program is constantly looking for things to improve or check. In other words go to preferences and turn of everything that probably uses the word 'Automatically.(do something)'. As further update on my post, I did get to the root cause of the problem, and although the above helped eventually I got the problem back so the above isn't the solution. Basically there appears to be a conflict with the fonts that Microsoft uses when you install Office, and the fonts that may already be installed on your mac. Firstly the mac has a default set of fonts that you cannot and should not remove.
![For For](/uploads/1/2/5/3/125360314/919830364.gif)
These are found under Macintosh HD SystemLibraryFonts. These fonts apply to all users in the system. Then there is the next level of fonts, that you may have purchased, or had installed by various programs. These are found on Macintosh HD LibraryFonts This is where I found the conflict.
I removed all the fonts from this folder (putting them in a temp folder on the desktop) and microsoft office ran like a dream immediately. I then put each one back one-by-one until I had identified the offending fonts, which by the way came from an older installation of office.
I cannot recal them now because they've all been permanently deleted from my system. There is another layer of fonts under each user just for completeness: Macintosh HD Users yourusernameLibraryFonts And you should check here too. I basically put all the fonts I found here into the folder in the desktop, and when they got put back it was at the level Macintosh HD LibraryFonts. Hope that helps Chris D'Costa. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.