Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 349
Default No data entry allowed in spreadsheet

Running Vista and Office 2007, things had been working decently until today.
Now, both newly created spreadsheets and old ones no longer allow us to enter
data into cells. It is as if the keyboard is dead, although the keyboard is
still working in all othe programs, and is still working for alt-menu
commands in excel.

In existing spreadsheets, cells can be edited indirectly, by going up top to
the formula bar, but this is very cumbersome.

This problem seems to have commenced when we created a file with a Microsoft
Template called "Charitable Gifts and Donations Tracker". Although the
problem started with this template, it now exists in all other excel
worksheets. This template appears to have the value TC100993111033 in the
Document Properties / Advanced Properties / Custom / Document Value in the
sub-sub-sub-sub menu described above.

The settings appear to be correct and normal in two areas I thought this
could involve--under the Vista tab Review for Protect Document, ad under the
Vista tab Formula for Calculate Now.

I wish Vista was as easy to work with as Windows, and 2007 as easy as 2003.
All the menus I have known by heart from 2003 are now only 30 to 40% useful
at best, becuase Microsoft's designers appear to have emphasized youngsters
who prefer the slower process of mouse clicking, and not considered very
fast, touch-typing power users when they changed to the ribbon. Example--in
Word, ALT-F, and then the letter "u" used to show the view of what a file
would look like before printing. Now it gives you the option to publish a
blog. There is no logic to this change--it is sheer bad engineering and
nothing more.

- Peter


Reply
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
No Data Entry Allowed Frustrated Excel user Excel Discussion (Misc queries) 1 February 20th 09 06:54 AM
Print titles not allowed: says 'entry cannot be used...' Chants1979 Excel Discussion (Misc queries) 0 January 24th 09 10:46 PM
Maximum number of variables allowed in an Excel Spreadsheet? cecilie Excel Discussion (Misc queries) 1 April 14th 08 06:48 PM
How do you get to the last data entry in a spreadsheet using shor. Sylvia Excel Worksheet Functions 4 April 15th 05 02:43 PM
Format spreadsheet so no input allowed if certain cell is =<0 Jan Buckley Excel Worksheet Functions 9 January 26th 05 12:21 AM


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

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

About Us

"It's about Microsoft Excel"