Mark Minasi's Reader Forum
Mark Minasi's Reader Forum
Home | Profile | Register | Active Topics | Active Polls | Members | Search | FAQ | Minasi Forum RSS Feed
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 HALP! Questions on Windows and Windows Server
 Office
 Excel copy/paste not always working correctly		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

clarkcomputer
Welcome Newcomer

USA
2 Posts
Status: offline
Posted - 06/25/2012 :  10:31:54 AM  Show Profile  Reply with Quote
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?
th

lady_mcse
Old Timer

636 Posts
Status: offline
Posted - 06/25/2012 :  1:23:46 PM  Show Profile  Reply with Quote
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.

Anne O'Day
MCITP: SharePoint 2010
Go to Top of Page

clarkcomputer
Welcome Newcomer

USA
2 Posts
Status: offline
Posted - 06/25/2012 :  1:47:59 PM  Show Profile  Reply with Quote
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.
th
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Mark Minasi's Reader Forum © 2002-2011 Mark Minasi Go To Top Of Page
This page was generated in 0.08 seconds. Snitz Forums 2000