LIST option missing in DATA Menu

A user has the LIST option missing in the DATA submenu of Excel 2003.
What would cause this and how do I help her correct it

--
cccgsmit
-----------------------------------------------------------------------
cccgsmith's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1524
View this thread: http://www.excelforum.com/showthread.php?threadid=26873

0
10/13/2004 2:16:33 AM
excel 39879 articles. 2 followers. Follow

1 Replies
563 Views

Similar Articles

[PageSpeed] 15

Perhaps she has short menus enabled. To change this --

Choose Tools>Customize
Select the Options tab
Add a check mark to 'Always show full menus'
Click OK

Or, to use short menus, and see commands that haven't been used 
recently, open a menu, and point to the arrow at the bottom of the menu.


cccgsmith wrote:
> A user has the LIST option missing in the DATA submenu of Excel 2003. 
> What would cause this and how do I help her correct it?


-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
10/13/2004 2:26:33 AM
Reply:

Similar Artilces:

Distribution List Changes
Hi All, I have a mail enabled distribution list with four users. Only those users plus the Administrator have rights on this group. Yet a seperate user is able to add / edit or remove users to this group even though they do not belong to this group. The user does not even have admin rights and is able to make changes. Let me know of any options I can try. Thanks Waynear wrote: > Hi All, > > I have a mail enabled distribution list with four users. Only those > users plus the Administrator have rights on this group. > > Yet a seperate user is able to add / edit or remov...

Entering stock options in money 2005
Hi, Just got Money 2005 and was surprised to find out that for each stock option grant, it wants me to open a new account!!! Did I just read the help incorrectly, or do I indeed need to open a new account for each grant I've received? TIA, -Nitin No, just one account. It will ask you what account would you like to put the option in. You can create a new one or select an already existing account in the list. Larry "Nitin" <nitin@pulcina.com> wrote in message news:e80e2a71.0410051556.22b05f3f@posting.google.com... > Hi, > Just got Money 2005 and was surprised to f...

Customizing Activities\History LIst
Is there a way to add a date to Activities' History list? It would be nice to know when each activity happened. Thanks, Troy Troy, no way currently, although Microsoft has mentioned it might be an option in version 2.0 (nothing is guaranteed!) A few ISVs have custom products that do it... www.salentica.com www.c360.com Dave "Troy" <anonymous@discussions.microsoft.com> wrote in message news:af6b01c436bd$ce671f00$a001280a@phx.gbl... > Is there a way to add a date to Activities' History > list? It would be nice to know when each activity > happened. >...

Better to "nest" or use multi-level list?
I'm in the process of creating/defining a style(s) for a list that will be numbered in "level 1" and have indented bullets in "level 2." For such a list is it better to define a multi-level list style and linked paragraph styles? Or use one's already defined numbered list and use one of the Word's pre-defined bullet lists when needed for the second level? As part of this question, is is preferable not to have a style "nested" within another style or doesn't it matter? Thank you. -- Norm Hi Norm: I'm not sure why yo...

Exchange Data Storage Question
I have an idea for my company on how to re-store our Exchange data to be more disk efficient (I/O wise) and would like your opinions. Right now Exchange 2000 is running on a PowerEdge 1750 (on Server 2000). The physical box has (and can only hold internally) 3 hard drives, and they’re running Raid 5. I’ve read reports that Exchange has been set up on PowerEdge 1750's but the exchange database and logs are stored on a NAS, and I think they use a PowerVault in the example I read. We have a Dell PowerVault 220S that is attached to a *different* server (not to our Exchange server)....

Sound shows on custom Annimation list yet no sound heard
When the PP Presentation is saved as a show,some slides have sound and some do not. All sound came from the same folder. Also, when playing the slides while in PPPresentation, swome have sound and some do not despite all being indicated on custom annimation lisy and all startin "after previous." Thanks! Often when one sound plays but another doesn't, it's an issue of the length of the file path. What's the file path to your music? Is it really long? If so, the longer-named songs might just be hitting the length limit. -- Echo [MS PPT MVP] http://www.ec...

Drop Down List and Check Box
Hi...I was search for this topic but don`t found the solve...Anyway I have a drop down list like this [image: http://www.geocities.com/augurtrade/excel_checkbox.txt] and this [image: http://www.geocities.com/augurtrade/excel_checkbox2.txt] ok my questions is what is (Blanks) and (NonBlanks)...? Is it possible for me to see only all the check box that was checked or vice versa...??? How to make a total below the checkbox i mean when someone check the check box, a total number appear below the last check box [image: http://www.geocities.com/augurtrade/excel_checkbox3.txt] [image: http://www.g...

Data Sort with header row
How can I set the default so that the "with header row" indicator is flagged as opposed to the "without header row"? Hi Ian, Don't think you can. You can help Excel make a guess by making the formatting of the header row differ from the data below it, by making the header Text, and Bold; which helps but is far from being reliable. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ian" <ian@ckf....

Moving data from popup to subform
I've created several popup continuous forms. The underlying table has no relationship with any other tables. They represent unique items for sale in a particular category. I have other tables like it of other categories, again with each item (record) unique. A form that contains customer information has a sub form for orders. They are linked by a customer ID. I intend to place buttons on the form to popup the categories forms as I need them. I want to select record(s) from the categories popups and create a new record with this data on the orders sub form. Thus, when I finish man...

option buttons #5
I am putting together a questionaire. And have two questions on thi questionaire that have option buttons. I want the participants to b able to click the option they want. However if they answer questio one and then answer question 2, the option button becomes unclicked fo question one because a button in # 2 was selected. So what I am tryin to figure out is how to keep them separate so they can both be answere by clicking the button. Thank -- Message posted from http://www.ExcelForum.com If the option buttons are from the Forms toolbar, you can put the pairs in a frame. If they are fr...

how reliable is the "Who has you in their contact list" list?
Because someone who I think has recently (within the last week) deleted me is still on this list (I don't think she blocked me), but when I check who deleted me on blockstatus.com, he shows up. could it be it's not updated? which of the two would be more reliable? -- maykk Greetings, Do not use these websites, they will steal your identity and sell it. You should change your password immediately. That said, in general, the "who has..." list within Messenger is accurate. There have been instances over the last six-months or so where the list (and m...

Sample Range of Data
I have created a sample using data analysis but I want the sample to include all of the columns, not just the sample #. For example if I use data analysis to select a random sample from a worksheet it will return just the sample area I selected. It appears I can only sample on numeric values so I have and the numbers 1, 2, 3....in the first column. What I would like to see is when it returns the sample that it returns all columns not just the first one. Hope I made sense. Jamie ...

Selecting from contacts list
I have all my contacts in the Contacts List and I want to delete all those with a common extension i.e. all those who have email addresses @hotmail. I am using Outlook 2007 Can you do a search or advanced search which will show the contact you want to delete? You should be able to highlight & delete them from the results. "GrahamC" <GrahamC@discussions.microsoft.com> wrote in message news:6AC1880D-9632-4ED9-BAE2-7083690B9FA7@microsoft.com... > I have all my contacts in the Contacts List and I want to delete all those > with a common extension i.e. all t...

Missing MB
Hi, Before I saved an Excel 2003 .xls file it was 168mb When it was saved as an Excel 2007 .xlsm macro-enabled workbook it shrunk to a mere 25mb Just curious where the other 143mb went to. 2007 can create files that are a lot smaller than 2003 and below. It seems to be smarter about storing redundant info in the file. -- Gary''s Student - gsnu200909 "Gotroots" wrote: > Hi, > > Before I saved an Excel 2003 .xls file it was 168mb > > When it was saved as an Excel 2007 .xlsm macro-enabled workbook it shrunk to > a mere ...

Script to list access right
Hi I am trying to find any script which would generate list of login users with certain access level (select, write etc.) at one particular database. Is there something like that? Thanks. Justin ...

a list of lists
currently i use CArray to keep track of a list of objects, but I don't know MFC classes well enough to keep track of a list of lists. I'd appreciate some suggestions "wanwan" <ericwan78@yahoo.com> ha scritto nel messaggio news:1187535523.924671.143350@j4g2000prf.googlegroups.com... > currently i use CArray to keep track of a list of objects, but I don't > know MFC classes well enough to keep track of a list of lists. I'd > appreciate some suggestions You might want to embedd your list based on CArray into a class (e.g. CListOfSomething), and then ...

Smart List export to Excel #2
Hi, We are using Dynamics 9.0 and Office 2003. When we try to do a Smart List export to Excel, we keep getting an "Exception_Class_Object_Exception" that references varying object errors, such as 'Cells' or 'Value'; the object errors will change each time we try an export. As a workaround, I've found that closing Excel before doing the export allows the export to complete successfully. However, that solution isn't acceptable, as our Dynamics users would like to be able to work in Excel, doing other tasks, while the export is processing. Does anyone...

List of different values in data area
Hi excel specialists, How Can I automatically get the list of different values from the dat area and to find out their frequence? INDIVIDUALLY MEASURED VALUES: 3,5 4 3,5 4 3 3,5 4 4 3 3,5 4 3 3,5 3 3 3,5 4 4 Thanks for your help in advance. Balcovja -- balcovj ----------------------------------------------------------------------- balcovja's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2623 View this thread: http://www.excelforum.com/showthread.php?threadid=39572 Take a look at FREQUENCY in Hep -- HTH RP (remove nothere from the email address if m...

Can data in one text box automatically appear in another?
I am trying to design a form in Publisher, and would like to link text boxes so that data entered in one will automatically appear in another on the same page. Is this feasible? How will this form be used? "G.O.G." <G.O.G.@discussions.microsoft.com> wrote in message = news:E4C951DF-7D4F-4FC1-8F6B-2C0B4EB8882A@microsoft.com... > I am trying to design a form in Publisher, and would like to link text = boxes=20 > so that data entered in one will automatically appear in another on = the same=20 > page. Is this feasible? Maybe with some programming... -- Mary Saue...

Global Address List and Handhelds
We use Ipaqs throughout the company, and I was wondering if there is anyway to have exchange add the GAL to the outlook contacts on the workstation, so that when they sync up, they will retrieve the Global Address List? In news:%23TkYtT0$GHA.3560@TK2MSFTNGP04.phx.gbl, Flip <phil.atkinson@beltek.com> typed: > We use Ipaqs throughout the company, and I was wondering if there is > anyway to have exchange add the GAL to the outlook contacts on the > workstation, so that when they sync up, they will retrieve the Global > Address List? No (and this wouldn't really be an ...

Fields in items list-- add/delete
Hai, I am using RMS version 1.2. In Stores Operations Manager it displays list of items when click on Database-->Items. It displays only five columns. Now i need to add / delete some fields in this list. Is it possible to add or delete the fields? if yes how can i add the fields? Thanks in advance, Nagendra On Wed, 27 Apr 2005 01:22:02 -0700, "Nagendra" <Nagendra@discussions.microsoft.com> wrote: >Is it possible to add or delete the fields? if yes how can i add the fields? I don't think so antonio ...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

Series with noncontiguous unequal length data?
I have 12 months of data and an average of the 12 months that are in a series on a chart. I reference the data using an offset formula. I would like to move the average at the bottom of the column of data to another column, but I don't know a way to still include that one cell in the series with the 12 months of data in the original column. Is there a way to do this? Thanks for any advice! Copy the cell that was moved. Select the chart. From the top menu goto Edit --> Paste Special... Make sure New Points is selected in the pop up dialog box, and click OK. That one point should be...

icon for XML data
Hi; We need a good icon that stands for "XML datasource." Is there anything out there in common use for that? thanks - dave david@at-at-at@windward.dot.dot.net Windward Reports -- http://www.WindwardReports.com me -- http://dave.thielen.com Cubicle Wars - http://www.windwardreports.com/film.htm Good day Dave, Just search out this one, http://www.iconlook.com/details.icon?id=14503&size=128 Best regards, Colbert Zhou (colbertz @online.microsoft.com, remove 'online.') Microsoft Online Community Support Delighting our customers is our #1 priority. We welcome your c...

VBA function missing its parameters
I'm creating my first VBA Excel formula in a couple years. I can pic the formula in the list of available functions, but the function' parameter is not visible. If I assign the formula to the cell anyway the cell only shows: #NAME? So, even when I pick the formula from the module, Excel complains abou the name. For example, the formula in the cell looks like: =test.xls!Module3.DoubleText() I can force a parameter into the function call, =test.xls!Module3.DoubleText("abc") but it doesn't matter since Excel doesn't see the parameter in th function definition. The e...