Results 1 to 5 of 5

Thread: Data form (XP)

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data form (XP)

    Hi everyone - hope all is well with all of you.

    Had a student stump me last night (WHAT you say?) Yep - no clue what the answer is to this one . . . we were using the data form to input data for the first time and someone asked me why the autocorrect functions didn't work within the data form - for instance, he typed monday instead of Monday and Excel didn't automatically capitalize the M - he also tried typing MOnday and that was not corrected either. I know (for some odd reason) you can't save your document while you're using the form, but this is a new one on me.

    Help, again - please.

    Aunt Linda

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Data form (XP)

    Data form is a rather old part of Excel 2002 that hasn't been updated for years - perhaps it predates AutoCorrect. Data are entered into the worksheet exactly as entered...

    Data form is a so-called modal form, i.e. you cannot click anywhere in the worksheet while it is open, neither can you use the menus or toolbars.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data form (XP)

    I assumed there was no way around this - thanks for confirming it for me. What about 2007? Did Microsoft address these little annoyances?

    Thanks for the help, again . . .

    Linda

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Data form (XP)

    Nope. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Data form (XP)

    Figures (not surprised)

    L

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •