Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click on column and Delete is greyed out?
Okay, I'm not entirely new to Excel, normally I can right click on a column
(with or without text) and then choose delete to delete it. Since having upgraded to 2003 professional, this option appears to be hit or miss. Most times it's greyed out, sometimes it's not. If I open Excel (new workbook) and type anything in a given column, most of the time I don't have the ability to delete the column. Point is, these are not linked or special spreadsheets I'm working with. I am running with the latest updates as well... Any suggestions? Thanks, Larry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click on column and Delete is greyed out?
Hi Larry,
One possibiity, although it seems remote: http://groups.google.com/group/micro...143bcd606eff5c -- Ken Hudson "Larry Cooke" wrote: Okay, I'm not entirely new to Excel, normally I can right click on a column (with or without text) and then choose delete to delete it. Since having upgraded to 2003 professional, this option appears to be hit or miss. Most times it's greyed out, sometimes it's not. If I open Excel (new workbook) and type anything in a given column, most of the time I don't have the ability to delete the column. Point is, these are not linked or special spreadsheets I'm working with. I am running with the latest updates as well... Any suggestions? Thanks, Larry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click on column and Delete is greyed out?
Thanks for the link Ken, though I'm not sure it would apply to me as I'm not
using any macros in these cases. I just checked and there aren't any macro's in the sheet(s). I just may reinstall office and see if that cures the problem... Larry "Ken Hudson" wrote: Hi Larry, One possibiity, although it seems remote: http://groups.google.com/group/micro...143bcd606eff5c -- Ken Hudson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click on column and Delete is greyed out?
Remote chance here since you said this happens to new sorkbooks too, but are
you working with a shared workbook that someone else is editing? I often see "normal" options disabled when working with shared workbooks... Good luck... stebro "Larry Cooke" wrote: Okay, I'm not entirely new to Excel, normally I can right click on a column (with or without text) and then choose delete to delete it. Since having upgraded to 2003 professional, this option appears to be hit or miss. Most times it's greyed out, sometimes it's not. If I open Excel (new workbook) and type anything in a given column, most of the time I don't have the ability to delete the column. Point is, these are not linked or special spreadsheets I'm working with. I am running with the latest updates as well... Any suggestions? Thanks, Larry |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Right click on column and Delete is greyed out?
No, not working on shared workbooks at the time.
The plot thickens though, I remembered last night that I had installed some security files (ADO stuff for Visual Office Studio I think...) Anyhow, the IT guy at our office created a worksheet that required this add-on from Visual Studio. He mentioned to me that he's having the exact same problem too so I think I may have found the source of the problem, just not sure what we need to do to correct though... Thanks, Larry "stebro" wrote: Remote chance here since you said this happens to new sorkbooks too, but are you working with a shared workbook that someone else is editing? I often see "normal" options disabled when working with shared workbooks... Good luck... stebro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
delete duplicate record but only determine 1 column data | Excel Worksheet Functions | |||
Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
ISSUE: Using VBA to Delete a Column | Excel Discussion (Misc queries) |