Question about Microsoft Office Standard for PC

1 Answer

Excel I a created a spreadsheet a few years ago and protected several fields so that i could share with everyone on my sells team. now i need to change the info in some of those fields but have forgotten how to unprotect those fields/pages. How do i unlock those protected fields/pages without having to rewrite the whole spreadsheet?

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers
Re: excel

If you remember the password, then all you need to do is select tools, unprotect worksheet and enter password

Posted on Sep 16, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

Excel Error Message.What can I do to stop this error?

A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.

Or if this doesn't work, one may take help of a third-party

For example Excel Fix Toolbox

Apr 24, 2015 | Microsoft Office Excel 2007

1 Answer

Not Enough Memory to run Microsoft Office Excel. Please close other Applications and try again..

Excel running on a 32 bit PC and using a 32 bit operating system can only address 2 Gb of RAM. If your machine has a 64 bit processor (these were being shipped over 5 years ago) it will be possible to install a 64 bit operating system such as Windows XP 64 bit or Windows 7 64 bit. It has been claimed that an Excel 2010 spreadsheet, running on a 64 bit machine and using Windows 7 64 bit, was able to load and use a database with 100 million records.

If you are unable to do this then I suggest that you examine what your machine is running at the same time as your spreadsheet and if any part of the spreadsheet can be off-loaded. By the latter I mean can any of it transferred to another Excel file?

Are you using any links on your spreadsheet, if so can the links be converted into data, e.g. a link to a lookuptable could be converted to data (copy, paste-special, value) and this remove a significant amount of processing load.

Oct 18, 2010 | Microsoft Excel for PC

1 Answer



There are two ways to do this, depending on what extent you want to protect the spreadsheet.

Windows Read-Only method:
  1. Save and Close the Excel file.
  2. Using Windows Explorer, locate the Excel file in its folder.
  3. Right-click on the file name
  4. Click on "Properties" at the bottom of the drop-down window.
  5. Check the [x] Read-Only box and [OK]
  6. * DONE *
Excel "Protect" Method:

  1. Open the Excel spreadsheet that you want to protect
  2. On the top menu, select [Tools]
  3. Click [Protection] on the drop-down menu
  4. Select [Protect Workbook]
  5. Check [x]Structure and [x]Windows
  6. Enter a password if you wish, but remember it!
  7. Click [OK]
  8. Save and close the spreadsheet and test the protection.
  9. *DONE *
Thanks for using FixYa.

Oct 06, 2010 | Microsoft Excel for PC

8 Answers

Password forgotten to acces my excel spreadsheet

Type "excel password recovery" into Google and you'll have a choice of many suppliers who sell software that will reveal an Excel password. I have tested most of their free trial version .Excel password recovery 5.0 is my favourite one,it is 100% recovery rate and easy to use.and most of all,it is the cheapest.just have a try

Jul 14, 2010 | Microsoft Excel for PC

2 Answers

Excel 2000 Issue???

.Let's start with this for more info:
Is the URL icon there but blank? (Maybe an X in the middle of the box?) If it's there, do the following:

Right-click on the URL
2. Select Hyperlink from the menu that appears
3. Is Remove Hyperlink box checked or unchecked?

This is a setting that is machine-specific. Post the answer as a comment and we'll take the next step if necessary

Apr 02, 2009 | Microsoft Office 2000 Professional for PC

1 Answer

Excel spreadsheet is protected. I do not remember the password. how can i get in?

lok on google for password cracker for excel download and it will open any locked spreadsheet

Oct 14, 2008 | Microsoft Office Standard for PC

1 Answer

Need a link

Macros are harder to understand than they are to create and use. Let me repeat "Macros are harder to understand than they are to create and use."
Here is the only understanding that you need. "they are used for repetive tasks" .

Now to the simple part of creating then using.
Get into your work and identify a task that you want to created macro for, Kapish? Just before you start on the task go into the macros screen and tell it to "create", then do your task. When through "push the stop button. Name the micro and save it. (the name may be the first step if so then give the darn thing a name, no big deal). The next time you are in the exact field where the identical task is going to be perforned you can call up the micro to run through the key strokes for you. Get ready for wildly unexpected results, with those understood you can go into the code and modify it. Or you can delete it and create anotherone that is cleaner. Keep doing this until you get the bugs out. By the way the once created micros leave a tag in the spreadsheet that alerts everyone that opens it to watch out for the dreaded micro you created.

Jun 20, 2008 | Microsoft Business & Productivity Software

3 Answers


The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

1 Answer

Average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

4 Answers

Forgot password

Try this link It should help you unlock the Excel file and break the password. Good luck

Sep 02, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides