ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I cannot edit work sheets on excel but i can view them. (https://www.excelbanter.com/excel-worksheet-functions/139615-i-cannot-edit-work-sheets-excel-but-i-can-view-them.html)

stewart pines

I cannot edit work sheets on excel but i can view them.
 
this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past. i have no
problem viewing them. what can i do to solve this problem. thank you.

Nick Klein

I cannot edit work sheets on excel but i can view them.
 
On Apr 19, 10:40 am, stewart pines <stewart
wrote:
this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past. i have no
problem viewing them. what can i do to solve this problem. thank you.


I would try going to Tools - Protection - Unprotect Sheet/Unprotect
Worbook. My guess is that the sheet is protected and by selecting
"Unprotect Sheet" or "Unprotect Workbook" you should be able to edit
it. If it's password protected then try to figure who set the
password and ask if you can have access.

If that doesn't work try saving the file as a different name and then
open that new file.


Gord Dibben

I cannot edit work sheets on excel but i can view them.
 
Stewart

All worksheets in all workbooks?

All sheets in one workbook?

What occurs when you try to edit any sheet?

Error message? Nothing?


Gord Dibben MS Excel MVP

On Thu, 19 Apr 2007 07:40:02 -0700, stewart pines <stewart
wrote:

this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past. i have no
problem viewing them. what can i do to solve this problem. thank you.



bj

I cannot edit work sheets on excel but i can view them.
 
do you have excel viewer on your computewr as well as excel?

"stewart pines" wrote:

this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past. i have no
problem viewing them. what can i do to solve this problem. thank you.


stewart pines[_2_]

I cannot edit work sheets on excel but i can view them.
 
thank you for helping out. you asked if i had viewer excel and i do. as for
excel i dont think i do anymore since i cannot find a way edit my worksheets.
ive had my computer for two years and this is the first time i run into a
problem like this. so if you think i should download a program please advice
me. thank you.

"bj" wrote:

do you have excel viewer on your computewr as well as excel?

"stewart pines" wrote:

this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past. i have no
problem viewing them. what can i do to solve this problem. thank you.


stewart pines[_2_]

I cannot edit work sheets on excel but i can view them.
 
thank you for replying, the only message that the computer sends is " could
not find Microsft excel to open file" what program should i download.

"Gord Dibben" wrote:

Stewart

All worksheets in all workbooks?

All sheets in one workbook?

What occurs when you try to edit any sheet?

Error message? Nothing?


Gord Dibben MS Excel MVP

On Thu, 19 Apr 2007 07:40:02 -0700, stewart pines <stewart
wrote:

this morning i tried to work on my worksheets using excel but for some reason
i could not edit any of the sheets that i had saved in the past. i have no
problem viewing them. what can i do to solve this problem. thank you.





All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com