| T O P I C R E V I E W |
| clarkcomputer |
Posted - 06/25/2012 : 10:31:54 AM
Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always with this one. Likewise the drag feature where one can grab the lower right corner of a cell and drag it down to past the contents of that cell into the cells below. Doesn't work sometimes. Similarly large numbers (13 digits) copied paste to a cell in text and are jacked up.
We've tried closing Excel and reopening. Rebooting. Even a complete uninstall and reinstall of Office. Not helped.
Any ideas? |
| 2 L A T E S T R E P L I E S (Newest First) |
| clarkcomputer |
Posted - 06/25/2012 : 1:47:59 PM
I could swap out the keyboard easy enough to test that idea. Thanks.
To your second point, though, if a setting is off, it's always off. This works sometimes. Related to that, only one user uses this PC. That's be a good place to look otherwise.
I might try a reset to defaults just see if that fixes it. She doesn't have it highly customized. |
| lady_mcse |
Posted - 06/25/2012 : 1:23:46 PM
I no longer have an Office 2007 box to test with. But the "intermittent" led me to wonder about something like a keyboard stuck key. ??
Also, you might want to consider wiping out the Excel options. An unsinstall\reinstall will usually preserve them. I'm looking at an Excel 2010 version, and see options in there like "Enable Fill handle and cell drag and drop." Maybe the user turned that off at one point, or other things in there that got changed without realizing it.
Here's an instruction set on changing Excel 2003 back to default options ... assume it should be similar for 2007:
http://office.microsoft.com/en-us/excel-help/reset-workbook-and-worksheet-settings-HP005202207.aspx
Regarding those options and that XLT file referenced in the how-to, that is going to be specific to the windows profile. So if she's someone who shares her computer with others, or uses different logons, that might explain the "intermittent"ness of the problems. Logs on one day as USer 1 with options set one way, and logs on as user 2 the next with options completely different.
|
|
|
