Validation Issue

I have a excel spreadsheet that was deployed to EVERYONE in my company and 1
person is having issues using the validation in it. Cells are restricted to
input from 1 to 5. She types a 1 and BAM.. Error. not valid input.. place
the same doc on a share and i open it. and look at that i can enter 1
through 5 with no issue. Have been banging my head on the wall for weeks..
Ran office updates and everything. Currently using office 2002 Pro. Also
rebuilt validation rule and still giving issues. Anyone have this same
issue?

If so please send me a response ASAP at the following email.

callen@ohc-llc.com


Thanks for everyones help in advance.


0
callen1 (1)
8/26/2003 4:18:36 AM
excel 39879 articles. 2 followers. Follow

1 Replies
402 Views

Similar Articles

[PageSpeed] 44

Is there any chance that she has formatted that cell as text?  (Or that it got
formatted as text somehow?).

I put Data|Validation in a cell:  Allow a whole number between 1 and 5.  1 works
ok.  I formatted the cell as text.  1 stopped working and caused the error.

I used xl2002 for my testing.  

What version is she running and what version are you running (but I don't think
that it makes a difference).

Chris Allen wrote:
> 
> I have a excel spreadsheet that was deployed to EVERYONE in my company and 1
> person is having issues using the validation in it. Cells are restricted to
> input from 1 to 5. She types a 1 and BAM.. Error. not valid input.. place
> the same doc on a share and i open it. and look at that i can enter 1
> through 5 with no issue. Have been banging my head on the wall for weeks..
> Ran office updates and everything. Currently using office 2002 Pro. Also
> rebuilt validation rule and still giving issues. Anyone have this same
> issue?
> 
> If so please send me a response ASAP at the following email.
> 
> callen@ohc-llc.com
> 
> Thanks for everyones help in advance.

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
8/26/2003 9:35:21 PM
Reply:

Similar Artilces:

Smartlist from View issue
When I created a new view and a Smarlist (GP 9) based on this view, for some reason no data shows up. GP briefly shows "Exploring" and quickly changes to "Completed" w/o showing any data. I've had this same issue previously and it was related to permissions not being set correctly but I've set this new one the same as the one that is now working but it's still not showing any data. FYI, I've enabled access to the view via both "Tools->SmartList Builder->Security->SQL Table Security" and "Tools->Setup->System->SmartLis...

Msgbox entry validation
The following Macro will not loop more than twice the error entries. Will someone help me correct it to loop indefinely? Thanks Sub Entry_validation() Dim Teststring As String Dim Inputstring As String Cells(1, 1) = "ABC" 'as given filename Cells(2, 1) = "DEF" 'as given filename Cells(3, 1) = "GHI" 'as given filename Cells(4, 1) = "JKL" 'as given filename errorloop: Inputstring = InputBox(prompt:="Enter Filename" & vbLf & "Enter abort to abort en...

Exchange 2003 cluster issue with DST update tool
Are there any issues or additional steps that must be adhered to when installing the DST udpate to Exchange in a cluster environment? (i.e. Do the Cluster Services need to be stopped before installing? Do the clustered servers need to be restarted?) I would say that approaching the update in the same way that you would apply a service pack would work well. There are a few pre reqs for this. It's an annoying update really and one that i dont think has been published well enough given its possible impact "smctigue" wrote: > Are there any issues or additional steps that ...

Visual C++ 6 support issue
I have a huge VC++ 6 MFC application (exe and dlls). How long will VC++ 6 MFC be supported by Microsoft....i.e. how long do I have before my application becomes unsupported and must be converted/rewritten to use .Net and/or MFC7? It is a good question. A lot of us wonder the same thing. Bottom line: until VS6 actually stops running, we consider VS7 only as a last-ditch solution. Since effecitively it hasn't been supported in years (SP6 came as a surprise to most of us), it is not something we've been overly concerned with. The real pain is fhe difficulty people have in getting VS6, ...

Data Validation -> Validation list is larger than the cell width
I have a workbook that I've just added data validation to one cell. FWIW, the data validation is based on a named range. Here's the (perceived) problem. When I've set up data validation in the past, the selection is the same width as the cell. In this case, the list starts almost a full cell width to the left. What am I missing? Thanks, Barb Reinhardt Barb, In Excel2003 I can replicate what you describe under the following conditions: 1. the named range contains entries that are wider than the data validation cell 2. The data validation cell is r...

ADC issue
I get the following error in adc tool log after i run adc tool how can i fix this.. Matched 'cn=JFOGEL,cn=Recipients,ou=NY01,o=EX01' to 'CN=JENNA FOGEL,OU=Users,OU=5th,OU=NY,OU=USA,DC=US1,DC=local' based on SID. In the last exciting episode, "cs" <chanbushah4@hotmail.com> wrote: >I get the following error in adc tool log after i run adc tool how can i fix >this.. > >Matched 'cn=JFOGEL,cn=Recipients,ou=NY01,o=EX01' to 'CN=JENNA >FOGEL,OU=Users,OU=5th,OU=NY,OU=USA,DC=US1,DC=local' based on SID. Doesn't look like an error. I...

Validating against a DTD
Hello All, I am trying to validate an xml file against a DTD. I went through a lot of examples especially: http://www.xmlforasp.net/codebank/util/srcview.aspx?path=../../codebank/System_Xml/XmlValidatingReader/Validator/validator.src&file=validator.cs&font=3 but its not working in my case. First of all, when i try to add my DTD file in XmlSchemaCollection object, it throws an error saying DocType element is expected. I am using NITF DTD for this and there is no DocType element in it. Any help will be appreciated. Thanks. VD You should not add DTDs to XmlSchemaCollection. XmlSchema...

Dont sent meeting to this attend issue
I use OL2003 on Exchange Server 2003. When I set up a meeting request and invite delegates you can (theoretically) go back into the meeting request and add additional delegates or just send to some of the delegates listed. What I have done is marked the delegates I do not want to email as "Dont send meeting to this attendee" which then crosses them out. I then send an update and I am then prompted with options * Send updates only to added or deleted attendees (default) * Send updates to all attendees So I go with the default which sends to the added person but ...

Validation dropdown list is not coming visible
Hi, I'm using XP and 2003. I have a problem that I have once found resolution, but now it came again and cannot remember what needs to be done. Here is the problem: There is a column where Validation is specified in right manner with error message in case of error. When selecting the cell - dropdown list is not coming visible. In case I write something wrong it gives error message. If I recall correctly - it was something to do with some kind of list. How can I change this to work properly? I tried to paste new column from another file where the column is working as I want...

Data Validation
Hi all I want to set data validation on a cell so that it will accept the following (and only the following) text strings: (1) "BR" (literally) or (2) "NT" (literally) or (3) "nA" where n is any positive integral numerical value including zero and A may take any of the values "L", "P", "T", "V" or "Y" or (4) "An" where n is any positive integral numerical value including zero and A may take either of the values "K" or "D". Is this possible, please, and if so how? thanks -- Return e...

excel 2003 issue
Hi all, I am a newly joined chennai guy for this group. thanks for allowing me to join. can anyone please solve this problem. I am working as a tech-support for a software company. I could not find a solution for this. Please help. In Excel 2003 when i am opening a file which has 4 worksheets in it, it is asking for a update link dialog box, where iam routing the same to the source file. but after that too, it is not updating the fields in the excel. other info is it is asking the same file to link. Then i tried opening the same file in another machine which has office 2000. it is asking th...

Color Scale Issue 2007 to 2003
I am using Excel 2007 and utililize fill colors to color code various reports which are sent to users running Excel 2003. I am saving these files in compatibility mode before sending them out. I am having problems with the fill colors I am using in 2007 not displaying correctly when viewed by 2003 users. Is there anyway I can utilize the Excel 2003 color scale in Excel 2007 so that the fill colors display correctly when viewed in Excel 2003? -- Jim I haven't tried this, so I'm not sure if it will work, but my suggestion is: have a user send you an excel file created in ex...

reinstall-validation problem
Hardware hit from lightning so new hd and video card and start over. All goes well with install using a slipstreamed XP-Pro SP3 disk but I notice it never asks for the Product Key during install yet it Activates itself during one of the boots and I think little of it until ... During the updates which followed (100+!!!) I notice Windows Defender doesn't seem to run or leave itself installed. As it is running on my laptop figured I just download it. When I run it, it wants to first do the Genuine Advantage bs which I let it, at which time it says "bogus". Ugh, g...

Validation
Julie the same can be achieve without going thru the double drop down boxes. You could do it just using the combobox alone. Thank again Please stay in the ORIGINAL thread. The archives will thank you. -- Don Guillett SalesAid Software donaldb@281.com "JLong" <anonymous@discussions.microsoft.com> wrote in message news:034101c49c3b$889b5020$a501280a@phx.gbl... > Julie the same can be achieve without going thru the > double drop down boxes. You could do it just using the > combobox alone. Thank again ...

Data Validation
I have set up a data form and have data validation rules on the various input cells. I see that there is an option called "Ignore blanks" in the data validation settings, which is supposed to restrict someone from entering past an input cell without entering valid data, if the "Ignore blanks" box is unchecked. I have tried to do this, but it does not seem to work. Please could someone tell me what I am doing wrong? Provide information, or better yet, a screen capture of the Data Validation dialog box with the Setting tab selected (User ALT+PrintScreen to copy the imag...

validating macro
Hi I am sending a spread sheet out to branchs I need them to complete a sheet (common info) before they do anything else on the workbook. I am looking for a macro or code for VBA which who check (common info) see if the cells are complete if not bring up a error screen informing the user to complete the form and then take them straight to the (common info) sheet. and if possible let them go to the tab which they want to go to. Use an extended version of something along these lines: (if there are lots of cells use a 'for row numbers x to y' or 'do until' statment, o...

Exchange 2003 with 2 AD Domains and migration issues
I've upgraded the messy NT4 network that I inherited at my company to Active Directory with 2003 Domain Controllers. Orginally, I used ADMT and the ADC to migrate users from NT4 and migrate the Exchange 5.5 accounts to AD. For some reason, during the upgrade, could not install Exchange 2003 in the Exchange 5.5 Site. For some reason it refused to find or communicate with the Exchange 5.5 server. So, I decided I would just export the Exchange 5.5 mailboxes using ExMerge and import them into Exchange 2003. I've been able to test this with my mailbox and it has worked fine. (I had to...

2003 Standard to Enterprise Upgrade Issues
Hello all...I have seen alot of things around the net for my problem and not having much luck. So please forgive if this is a simple fix. Just upgraded from 2003 Std to Enterprise. Now my OWA users can only use IE inside the network......and not via my SSL reverse proxy. But all users outside who use Firefox/Mozilla have no problems at all. I am pulling my hair out (what little I have) and am not making any progress....can anyone give me some ideas of where to look too. Before the upgrade all was well. Thanks On Fri, 25 Mar 2005 17:49:01 -0800, "Paul Yahnig" <Paul Yahn...

Property Page with CListCtrl Repaint issue
I have a customized Property Sheet/Page custom class that allows me to create a property sheet with "tree menu" pulled from the titles of the property pages and allows me to display the page as you select the tree items. Problem: When the main program no longer has focus and another program is now on top, when returning back to the main program, the current property page is no "repainted." I narrowed it down to pages that contain a CListCtrl control and this control has the FOCUS when the behavior is exhibited. If the control doesn't have the focus, no problem. I a...

Reboot Validator
I'm running XP Pro, SP3. Attempting to install a program from Nero. Software keeps failing at startup, despite numerous re-installs. During installs, it keeps attempting to update the 'reboot validator' which it does not seem to be able to do. What is the reboot validator, and how do I update it. Couldn't find anything useful on MS site and Nero Tech support just says its an MS problem. -- Thank you, B. Parker Never heard of it but Nero Support should know about it: Reboot Validator appears to be a Nero component; cf. http://www.brighthub.com/comput...

Conditional validation?
Hello All I have a sheet that is essentially just columns of data (except for the column headings in the first row), and two of the columns are what I would call 'mutually exclusive': i.e. if a value is entered in a row in either column, the user must be prevented from entering any value in the same row of the other column. The two columns already have some basic validation applied (ranges of permissable numerical values), and this validation would need to be applied for any values that are entered. I am sure this can be done, but cannot see how! Hope someone can help. Many thanks L...

XslCompiledTransform Issues
How do I do the following using streams instead of actual files. I've tried it using memory streams for the input/and output but I don't seem to be able to get the output stream to contain anything. Friend Shared Function ApplyTransform(ByVal strXSLTransform As String, ByVal objReport As Xml.XmlDocument) As XmlDocument Dim settings As New XmlWriterSettings() Dim tmpdoc As New Xml.XmlDocument settings.Indent = True settings.IndentChars = vbTab Dim writer As XmlWriter = XmlWriter.Create("c:\output.html", setting...

REPOST: dynamic validation
I think I wasn't clear that I need the Validation option under the Data menu, List, source values. That is what I am trying to fill with this equation. In other words, range1 and range2 are sets cells which contain values. I want those values to be the dropdown options in the cell based on what the previous cell to the left is selected as. So if Range1 is three cells with Tall, Dark, Handsome and Range2 is Sweet, Pretty, Nice, then based on the selection of F or M in A1, I want the choices for B1 to be one of those lists. I know that quotes are required for the IF. My probl...

Excel 2000 vs 2002 Sheet protection & Validation cells
Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu (validation with 50 choices) Everything works very well. I sent this file to a friend who has Excel 2002. The same "unprotected" validation cells cannot be modified in his version as the message says that these cells are protected What can be done in order to make it work on his version?? I do have some "very hidden" sheet with password protected VBA properties, if that is an issue. Similarly there are some macros o...

How to use data validation
[NB: I re-structure my question since people got misled from my previous one] What I really wish to ask is: I wish to use data validation for a particular cell. But it doesn't work if I choose "custom" in the "allow" box. 1) In Data | Validation | Settings Tab | Validation Criteria, there is an "Allow" Box. 2) I chose "custom", there is a formula. 3) I type in some formula, eg: =J3 (Just Reference) =J3-J1 (Reference-type formula) =round(J1) (Function-type formula) None of them can activate the validation fu...