Home |
Search |
Today's Posts |
#1
|
|||
|
|||
why does right click on row bring up save as?
In Excel, I used to be able to right click on the left side of a column on a
worksheet and it would select the entire row. I could then copy the contents to another worksheet. Now when I right click, the Save As box opens. I don't know what happened to change that and how to make it stop. Please help. I'm using Excel 2002 SP-1. |
#2
|
|||
|
|||
why does right click on row bring up save as?
Hi newbie consultant
Try this Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb. The .xlb file has all Toolbar customization in it. 1. Close Excel 2. Do a search for .xlb in Windows (Use: search hidden files and folders) 3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb) 4. Start Excel Deleting the file or renaming will do no harm on your system Excel will create a new one for you. (You lost your customization remember that) If you make your own toolbars or add buttons to the others this file is important (backup it so you can restore it) -- Regards Ron de Bruin http://www.rondebruin.nl "newbie consultant" <newbie wrote in message ... In Excel, I used to be able to right click on the left side of a column on a worksheet and it would select the entire row. I could then copy the contents to another worksheet. Now when I right click, the Save As box opens. I don't know what happened to change that and how to make it stop. Please help. I'm using Excel 2002 SP-1. |
#3
|
|||
|
|||
why does right click on row bring up save as?
Perfect! This really helped. The .xlb was at 51 kb. Thanks!
"Ron de Bruin" wrote: Hi newbie consultant Try this Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb. The .xlb file has all Toolbar customization in it. 1. Close Excel 2. Do a search for .xlb in Windows (Use: search hidden files and folders) 3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb) 4. Start Excel Deleting the file or renaming will do no harm on your system Excel will create a new one for you. (You lost your customization remember that) If you make your own toolbars or add buttons to the others this file is important (backup it so you can restore it) -- Regards Ron de Bruin http://www.rondebruin.nl "newbie consultant" <newbie wrote in message ... In Excel, I used to be able to right click on the left side of a column on a worksheet and it would select the entire row. I could then copy the contents to another worksheet. Now when I right click, the Save As box opens. I don't know what happened to change that and how to make it stop. Please help. I'm using Excel 2002 SP-1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
cannot edit and save | New Users to Excel | |||
How to save file to a specific folder? | Excel Discussion (Misc queries) | |||
save as html | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |