LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35
Default Adding more options in a drop down list

I would like to add to a drop down list that is in a column of an excel
spreadsheet. I can insert a line and then when I try to add or change the
drop down list, I get the following error:
"THE VALUE YOU ENTERED IS NOT VALID. A USER HAS RESTRICTED VALUES THAT CAN
BE ENTERED INTO THIS CELL."

I received this spreadsheet from a coworker that had created it. I believe
they may have copied the information from another spreadsheet. Is it possible
she brought some protected information with it?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
color options from drop down list always needs help Excel Discussion (Misc queries) 0 October 24th 07 05:08 PM
how do I use one drop-list to modify another drop-lists options? [email protected] Excel Discussion (Misc queries) 3 September 9th 07 05:46 PM
Assigning values to drop-down list options i*sam Excel Discussion (Misc queries) 3 May 22nd 07 04:43 PM
validation list with drop down list of options?? luke013 Excel Worksheet Functions 1 August 31st 05 01:16 PM
How do I set up a drop down box in Excel with a list of options f. Debbie C Excel Discussion (Misc queries) 1 March 31st 05 12:16 PM


All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"