Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Summer
 
Posts: n/a
Default I'm unable to type in any new data in an Excel file.

I'm having trouble modifying an Excel 2003 file. I opened the file and
attempted to enter new data in a spreadsheet. Perhaps I hit another button
in the process....now I can't type anything into an excel file. Most of the
menu options and control bar links are shaded as to disallow use. What did I
do and how might I fix it????
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael M
 
Posts: n/a
Default I'm unable to type in any new data in an Excel file.

Hi Summer
Where did the file come from ??
Is it a read only file, say on a CD ??
If it is on a CD you will have to copy it to your HD first, before you can
make any changes to it.
If you haven't made any changes already, close it and reopen and start again.

HTH
Michael

"Summer" wrote:

I'm having trouble modifying an Excel 2003 file. I opened the file and
attempted to enter new data in a spreadsheet. Perhaps I hit another button
in the process....now I can't type anything into an excel file. Most of the
menu options and control bar links are shaded as to disallow use. What did I
do and how might I fix it????

  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default I'm unable to type in any new data in an Excel file.

You state you can't type anything.

What happens when you try? Error message? Nothing?

What if you open another workbook? Same problem?

If not, perhaps your sheet has been protected. The grayed-out menu options are
a hint to that.

ToolsProtectionUnprotect sheet may help you.


Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 21:53:01 -0700, Summer
wrote:

I'm having trouble modifying an Excel 2003 file. I opened the file and
attempted to enter new data in a spreadsheet. Perhaps I hit another button
in the process....now I can't type anything into an excel file. Most of the
menu options and control bar links are shaded as to disallow use. What did I
do and how might I fix it????


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
Cannot save external data into file excel system show not respondi Domino415 Excel Discussion (Misc queries) 0 May 31st 06 09:01 AM
Unable to open an excel file on desktop, must open excel first Smitt Excel Discussion (Misc queries) 1 January 11th 06 09:20 PM
Excel 2003, Convert EXISTING Worksheet Data to XML? [email protected] Excel Discussion (Misc queries) 4 November 16th 05 04:45 AM
Append the data given in diff sheets of an Excel File to one sheet sansk_23 Excel Worksheet Functions 3 May 10th 05 02:00 AM
Getting data from another excel file Union70 Excel Discussion (Misc queries) 0 May 2nd 05 02:17 PM


All times are GMT +1. The time now is 09:07 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"