Over 1 million tech questions and answers.

How to remove password protection in excel file

Q: How to remove password protection in excel file

how can i over write password in an excel file? actually it is my file but someone put password on it how can i get rid of that password?????

RELEVANCY SCORE 200
Preferred Solution: How to remove password protection in excel file

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: How to remove password protection in excel file

Your best bet is probably googling "Excel password" and seeing what comes up. There are MANY many utilities out there for finding out the passwords in a spreadsheet, and you should be able to find one that works for you.

Do note, tho, most of the good ones are commercial

Read other 3 answers
RELEVANCY SCORE 79.2

Hello,

I have a PDF file that is protected by a password. I tried almost all free online tools to unlock the password but they don't work. I know the password but online tools are showing the error: The uploaded file does not seem to be a valid PDF file.

Please let me know if there is any online tool or any software that can remove the password so I can share the file with others

Thanks
Steven

A:How Can I Remove Password Protection From my PDF File?

I know the password but online tools are showing the error: The uploaded file does not seem to be a valid PDF file.
Perhaps the file is not a .pdf file after all.
Anyway, .pdf files are generated by Adobe Acrobat, not by Windows. Checking the FAQs at the Adobe site is probably the best way to solve your problem. I would also run this test: Create my own .pdf file, apply a password, then remove the password.

Read other 4 answers
RELEVANCY SCORE 65.2

Hi Guys

I'm having a problem with a user on Excel, the file is an xlsx (Excel 2007 Format) we are using Excel 2000. The Microsoft compatibility pack converts the file to a readable format, the problem is it asks for a password to open it.

I have tried and I can open it, plus a few others have also tried and have been able to open it. It seems to be this one users profile but not sure whatís causing it any ideas?

Regards

shenmue232
 

A:Excel Password Protection

Might want to ask a moderator to move this to the Business Applications category. You can do so by clicking Report on your first post.
 

Read other 1 answers
RELEVANCY SCORE 65.2

I have an Excel workbook titled "Password" in which I keep all the passwords I use (lots) - this workbook is password protected so I really only need to remember one password
This morning when I got to work I opened the workbook
It asked for the initial password which I entered and was accepted
It then opens the dialogue for the Write or Read Only
Under the line
"PASSWORD" IS RESERVED BY
it gives a line of funny characters (blocks etc) which I had never seen before
Whether I enter the password or select ReadOnly I get kicked out of Excel
with a blank dialogue box headed PROGRAM ERROR
I tried several times and even rebooted with the same results
Please help
 

A:Excel - Password protection

Hi meksteen,

is the spreadsheet on a networked drive or are you on a network?

if so ask your administrator to check if the file has a lock against it, if so clear it, then you can try to open it again.

not sure if this helps, otherwise you spreadsheet may be corrupt (gulp).

Hew
 

Read other 2 answers
RELEVANCY SCORE 64.8

Morning from England,

One of our clients has a problem, when they receive an email with a password protected excel sheet and try to open it, they get a message saying that the password is incorrect and to verify that caps lock isn't on, before they even have a chance to enter the password.

Apparently they could do this last week, but not today.

They can save the excel attachment and open it that way and it allows them to put in the password. (But I don't think she is interested in doing this and I have no idea why it matters, but the customer is always right, apparently)

I know you should never take the story of the client as gospel, because most of the time it is wrong, but I'm just wondering if it is possible to open a password protected excel document from outlook, or does it have to be saved first?

If you can open one from outlook, how can I fix it.

Thank you for any help provided.
 

A:Solved: Excel Password Protection

When an excel file is password protected it will always prompt for a password.
If you open an attachment in Outlook, a copy is placed in the local temp folder but it's still Excel and it will still ask for a password.
I think your client has the following problem:
If you have preview frame on, it could be that since you want to 'preview' the message an maybe the Excel file too, it will prompt for a password to open it in the preview, this would explain the reason the password prompt appears, ask your customer to colse the preview option and try again.
In teh Excel file allows to read without a password but edit with a password then they should get the choice Open as read only besides the password prompt, so.
A client may be king but not everybody has to bow for a king.
 

Read other 2 answers
RELEVANCY SCORE 64

Unlock Password Protection from Excel Workbook with the help of Mask Attack, Dictionary Attack, & Brute Force Attack by eSoftTools Excel Unlocker Tool. You can also, Unlock Word file password and Access file password with supported versions up to 2019 and Windows versions up to 10 (32-bit, & 64-bit). User can try its FREE DEMO VERSION to satisfied with this software working process.

Get More Info:- Search On Google eSoftTools Excel Password Recovery
 

Read other answers
RELEVANCY SCORE 64

I am using Excel 2000 and have a spreadsheet that is password protected from a previous employee. I have saved the sheet under another name with no luck and I have used the edit/Move or copy command to move the sheets to another workbook with no luck. Any other suggestions? Thanks
 

A:Excel Password Protection Problem Follow up

http://www.theofficeexperts.com/VBASamples/Excel02.htm
 

Read other 1 answers
RELEVANCY SCORE 63.2

                                                                                                                                                                                                                                                          ... Read more

Read other answers
RELEVANCY SCORE 62

My admin account has password protection. How can I remove the password protection? Thanks

Read other answers
RELEVANCY SCORE 60.8

I recently have been looking into putting passwords on my files, to protect myself from hackers and from prying eyes cough**mom**cough. I tried using TrueCrypt but its a pain to have to mount the drive every time you log in, then dismount when you log out and keeping the program open. I've also tried putting opening a notepad document and implement this code:
cls
Echo OFF
title Folder Private
if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK
if NOT EXIST Private goto MDLOCKER
:CONFIRM
echo Are you sure you want to lock the folder(Y/N)
set/p "cho=>"
if %cho%==Y goto LOCK
if %cho%==y goto LOCK
if %cho%==n goto END
if %cho%==N goto END
echo Invalid choice.
goto CONFIRM
:LOCK
ren Private "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
attrib +h +s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
echo Folder locked
goto End
:UNLOCK
echo Enter password to unlock folder
set/p "pass=>"
if NOT %pass%== 'insert password here' goto FAIL
attrib -h -s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}"
ren "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" Private
echo Folder Unlocked successfully
goto End
:FAIL
echo Invalid password
goto end
:MDLOCKER
md Private
echo Private created successfully
goto End
:End
This would work but it is quite easy to bypass the password function and read the files.
Any suggestions? I am looking for just a double click on ... Read more

Read other answers
RELEVANCY SCORE 60.4

OK, so I backed up a crap load of songs from my desktop to my extrnal hard drive. but i guess protected audio files got messed up and now I have to download the license which only last on an average for 30 days. Anyone know a way to remove the protection encryption? thanks so much.
 

A:Remove WMP file protection

Fair Use should remove the DRM copy protection, from Here
 

Read other 1 answers
RELEVANCY SCORE 60

Is there any way to provide privacy to certain folders and such so that the contents are not included in search results and are not accessible to any user? Does anyone know of a way without buying a program? If that is not possible what program is the best to use?
 

A:Password Protection for File Folders

Read other 6 answers
RELEVANCY SCORE 59.6

Dear everyone,

I would like to make a folder share from a tablet with windows 8 with password protected to a laptop of windows 7 and another of vista.
I have followed the tutorial of File Sharing - "Share with" & "Stop Sharing" in Windows 8. My PCs have been set in the same workgroup and same user account, network discovery and file and printer sharing turned on.
At the first time, it is OK for windows 7. However after some changes of account (delete and create them on both windows 8 and windows 7), it doesn't work anymore with the error from windows 7 "Login failure: user has not been granted the requested logon type at this computer" whenever password protected turned on in windows 8 and only OK when password turned off.

Could you give me a recommendation.
Thanks a lot.

A:File sharing with password protection from windows 8

Hi everybody,
The current status has been changed as follow (I don't know exactly what setting causes these changes):

(1) When I log in Windows 7 with the same account as in Windows 8 and even if turn on or off password protected sharing at Windows 8, the PC icon of Windows 8 in Network can be opened but its sharing folders cannot be opened from Windows 7 with the error "Windows cannot access \\<PC name>\<folder name>. You do not have permission to access \\<PC name>\<folder name>. Contact your network administrator to request access".

(2) When I log in Windows 7 with the different account from Windows 8:
- If turn on password protected sharing at Windows 8, the PC icon of Windows 8 cannot be opened from windows 7 with error "Login failure user has not been granted the requested logon type at this computer"
- If turn off password protected sharing at Windows 8, the same error as the case (1) arises

Please give me a solution to make sharing with password protected.
Thanks.

Read other 1 answers
RELEVANCY SCORE 59.2

This is a bit of a cross forum question. I have some excel files that have both cell and structure protection enabled.

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingColumns:=True, AllowFormattingRows:=True

This has resulted in a significant reduction in compression ratio from 89% to only 11%. Since these are large files, its an issue.

I've tried WinZip, WinRAR, 7-zip, CabPack etc, etc. Any ideas??.

Tom
 

A:Solved: Excel File Protection Affects Compression Ratio

Compressing works by reducing sequentially repeating characters or character groups to tokens. Encryption changes all the characters to make the file look like gibberish, and in the process reduces the occurrence of sequentially repeating characters or character groups, particularly white space which often accounts for the majority of compression in Excel files. By using encryption, you are trading compression for security.
 

Read other 3 answers
RELEVANCY SCORE 58.4

Less than a month ago I build a new rig, installed Windows 7 on my SSD and at a later time I attached my old 1TB large disk with still had XP installed on it.

Windows is protecting this drive, all folders are flagged read only and I'm unable to remove the read only flag, each time I try, and check back after processing a job to un flag it, there still there.

I'm able to delete files and folders after accepting the UAC popup, however, there are several folders I want to remove but am unable to, /Boot, /Documents & Settings, /Windows and some root system files, but windows doesn't let me.
(I need to run programs with elevated rights in order to be able to modify those files)

The /Boot is from an older Windows 7 install and it should be safe removing it, because I installed windows 7 on a SSD with out any other disks attached, so no dual boot stuff.

But worst of all, many files are also flagged read only, along with my project files that I'm now unable to modify.
What buttons do I need to press to get windows to understand he should not be protecting this disk and there ain't no windows installed on it so I can clean up get rid of those read only flags on the files

A:Trying to remove Windows system file protection from 2nd disk

Try this:
Take Ownership of file - Vista Forums

Read other 4 answers
RELEVANCY SCORE 55.6

I was trying to change the password required to open one of my MS Excel workbooks and I must have done something wrong. The file is still password-protected but neither of my passwords (old and new) work any longer. So, I cannot open the workbook.

Is there a way of retrieving/resetting the password for an Excel workbook/file? I have also heard that there might be programs that could crack open the file by trying a large number of password combinations. Any help in this regard would be greatly appreciated. Thank you.

Michael
 

A:I must have done something with my Excel file password

Michael,
Check the TSG Rules:
"Other Illegal Activities - As you might expect, we don't want anything illegal going on here. Users cannot post hacks, cracks, pirated software, or anything of the like. Furthermore, we do not allow instructions on how to complete illegal activities, such as pirating. Please don't ask for advise on using illegal software, as it will be removed."

Richard.
 

Read other 3 answers
RELEVANCY SCORE 55.2

I do not want to hack. Just want to remove password protection from that file. I know it's password.

A:How to remove password from rar file? (i know the password but)

I think it would be easier to just copy the uncompressed contents to a new rar without a password.

Read other 6 answers
RELEVANCY SCORE 55.2

Hey,

I'm looking for an app to break a forgotten password for a friend - excel file
I've downloaded a few apps, but they have restrictions in demo mode.

Anyone know of a freeware app that works?!

Thanks in Advance
 

A:Lost Password for Excel File

Read other 8 answers
RELEVANCY SCORE 54.8

At the bottom of the File menu in Excel there are number of file names left over from the last time that you worked in them. Is there a way to remove these file name tracks? It occurred to me that if someone happens to come across your unguarded computer at work they will know what you've been working on recently.
 

A:How do you remove file tracks in Excel

Read other 6 answers
RELEVANCY SCORE 54.4

hii. any body know how to remove password from a pdf file without using any software, of with software.
 

A:how to remove password from a pdf file.

Why do you want to remove the password, and where did it come from?

eddie
 

Read other 3 answers
RELEVANCY SCORE 54.4

Dear Support,
How to remove forgetten password from .pst file.
I use OS win7 professional and Ms office 2013. So please help me for removing forgetting pst password.

When I add pst file in new outlook. Then Pst file ask password.
please help me.

I will be thank ful to you.

A:remove password from .pst file

the goals of a password is to protect the contents from anyone who does not know the password.
As far as I know, there are no tools provided by Microsoft to remove, alter or read the password from a protected pst file. It might even violate local laws to do so.
https://support.office.com/en-ca/article/I-forgot-my-Personal-Folders-file-pst-password-cfaec399-0de7-4f8f-a81b-918b38867ed6
Some third parties might claim to have tools that remove, alter or read the pst password, but I should urge you to be prudent when testing/using such tools (or paying for them).MCP/MCSA/MCTS/MCITP

Read other 4 answers
RELEVANCY SCORE 54

Hello,
 
I have 2 corrupted Excel files that I store on Microsoft SharePoint.  I store hundreds of other Excel 2013 files there, but 2 recently became corrupted.  Actually, the only 2 that became corrupted were password protected.  When I try to open each file, it says that they can't be opened because they are corrupted.
 
I've tried every available recover option and advice; recover formula, data, excel recovery software, open and repair, etc.  I believe that because the files are password protected, standard Excel recovery programs won't work.  I've tried 6 of the more common ones that come up in a google search and they all can't repair the file.  I can't remove the password because it won't open due to the corruption.  In other words, I don't have the option to enter a password because it says that it is corrupted before I have a chance to enter a password.
 
I've heard that it might be ransom ware or a virus, but nothing has popped up on my computer and all of my non-password protected Excel files are corrupted.
 
I've tried opening and repairing the file with Excel 2007, too...no luck.
 
I'm running Windows 8.1, Excel 2013.  Both corrupted Excel files are small...less than 300 kb.
 
I have the password, so has anyone else had this problem?  If not, does anyone know of someone I could hire to extract the data that I had in the spreadsheet?
 
*I have back-ups of these files, bu... Read more

A:Corrupted password protected 2013 Excel File

Hello, and Welcome
 
It is probably a long shot but it's possible your Sharepoint is set up to view previous versions. Check this link.

Read other 3 answers
RELEVANCY SCORE 54

any solution? for remove winrar password. bcause i already forget the password. i really need that file. thanx for u all kind.

A:How to remove password at file winrar ?

Quote:




You may not ask for assistance with any deemed illegal activities such as but NOT restricted to the following::

software pirating
hacking
password cracking
keystroke recording software
assistance with accessing copyrighted software programs
Leeching on private or public WiFi/Broadband connections




The above is a snippet from the TSF Rules: http://www.techsupportforum.com/foru...ork&page=rules

I'm locking this Thread as we are not allowed to help in such matters.

Read other 1 answers
RELEVANCY SCORE 53.6

Hello guys,

Yes I know it is a silly question, but what is the syntax for removing the read-only attribute of an Excel file, say abcd.xlsx file?
The address of the example is, c:\documents\spreadsheets\abcd.xlsx.

Any help will be much appreciated.

Regards,
Flores

A:How to remove the read-only attribute from an Excel .xlsx file?

Right click on the file then choose "properties" in the window that opens and then uncheck the "read only" box at the bottom of the window.
BTW there is no such thing as a silly question but there are plenty of silly answers

Read other 1 answers
RELEVANCY SCORE 52

Hi,
I know that the default factory settings are saved in "C:\Windows\repair".
So if I forget my password then which registry file should I replace from "C:\Windows\repair" to "C:\Windows\system32\config" to set my password as nothing and also avoid losing my data.

I remember some one told me that the windows logon password is saved in SAM and SECURITY...or is it any one of them.

If this method is successful then does it apply on Windows Vista and Windows 7 equally well?
 

A:Can I remove my Windows login password by replacing Registry file?

Have you read the site rules, or forgotten what they are?

Passwords - Please do not ask for assistance with forgotten passwords and/or bypassing them. As there is no way to verify the actual situation and/or intentions, no assistance will be provided and any such threads will be closed
 

Read other 2 answers
RELEVANCY SCORE 50.8

Windows 7. I have a desktop and a laptop that were installed clean with the same OS version.

On a network, the laptop is able to stream my shared media to all other PC's on the network (one is running XP, another is running Vista). PASSWORD PROTECTED SHARING IS OFF

On the same network, any PC that tries to network into the desktop is prompted to enter a password.

The laptop is sharing folders on the home network from C:\. The Desktop is sharing folders on the home network from a second hard drive labeled E:\. The media on E:\ is mapped into the libraries (pictures, videos, etc).

These are all of the things I have tried.
- turned password protected sharing ON:†prompts a password
- turned password protected sharing OFF:†prompts a password
- Disconnected E:\ to share C:\ only:†prompts a password
- Set permissions to all computers on the network under Admin control:†prompts a password
- Allowed access through firewall:†prompts a password
- Disabled firewall completely:†prompts a password
- disabled wireless card and used LAN:†prompts a password
- used a completely different router:†prompts a password
- allowed sharing on E:\ in advanced settings:†prompts a password
- set permissions to Everyone on every single folder in E:\:†prompts a password
- banged head against the wall:†prompts a password
- raged:†prompts a password

Something to note: If I try to network into the laptop from the desktop, it too is prompted to enter a password for the laptop (this only happ... Read more

Read other answers
RELEVANCY SCORE 50.8

Hi Guys,

This is a curious one.

I have three PCs (two desktop and one laptop) all running Windows 10 Pro 64-bit (1607).

Each system has a shared partition, set up exactly the same, which has sharing set for 'everyone', with 'full control'.

Password protected sharing is turned off on each system (in "Control Panel\All Control Panel Items\Network and Sharing Center\Advanced sharing settings").

Each of the desktop systems can access each other's shared and also the laptop's shared partition.

The problem is when I try to use the laptop to access the shares on either of the desktop systems, I get a pop-up requester asking for a username and password. (see below - the laptop is "T400" and one of the desktops is "A960").

Any idea why this would be happening? I've checked the settings on all systems (sharing and network) and can see not reason for the password prompt appearing.

Previously I was running Win 10 Pro 64-bit (1511) on all three systems and never encountered this error.

Cheers,

Mike.

Read other answers
RELEVANCY SCORE 48.8

Immediately search great solution-Atom TechSoft 7z password unlocker tool to Repair & recover corrupt, damaged, erroneous zip file data without losing internal items. It completely
helps you to combat with all these possible errors without involving data loss. This 7 password unlocker utility is the mind-blowing technique for repairing 7z file password & also Supports Zip recovery of password protected zip files.
atomtechsoft/7zpasswordrecovery


 
 

Read other answers
RELEVANCY SCORE 48.4

Why isn't Windows File Protection Switcher disabling Windows File Protection after XP SP2 restart, like it's supposed to?
 

A:Windows File Protection Switcher Not Disabling Windows File Protection

Read other 8 answers
RELEVANCY SCORE 48.4

Hi there,

I am trying to use SQL.REQUEST to pull data from one excel file (a master data file) to another one, and I can't get it to work. I think I don't have the correct connection string specified.

I'm using Excel 2002 on Windows 2000.

The task is, I need to build dynamic queries based on other cells in the "output" spreadsheet, such as, get a count of all records in the master file where the date field is equal to [cell reference] and the ID field is equal to [another cell reference] and a third field is equal to [third cell reference]...
So that, if the values in those referenced cells change, the records that match (and get counted up) will be different.
Also, there will be at least 10 different queries (I do a sum on a field that is a time duration, an average on that same field in another, etc) in different places on the spreadsheet.

I was able to get a simple query to work in Microsoft Query if I used static values, ie, I typed them directly into the criteria... however, these need to by dynamic so that when the same spreadsheet (a report template) is "saved-as" and new values for the criteria are input, the queries don't have to be re-created.

So, using MS Query, I can connect to the master data file and get the correct result... but I believe what I really need to use is SQL.REQUEST, so I downloaded the ODBC add-in and installed that.
I just can't seem to figure out what my connection string argument needs to be.
Th... Read more

A:Solved: sql request in excel file, to another excel file - connection string?

Nevermind folks - I googled +excel +"connection string" for probably the 20th time in 4 days... I usually investigate all result about 7 pages deep before giving up, and this morning, all of a sudden a new result popped up right at the top:
http://www.connectionstrings.com/excel

at about the same time, my boyfriend finally took a look at it, and he came up with this result: http://www.devlist.com/ConnectionStringsPage.aspx

I used the syntax in this example
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";
AND IT WORKS!
(I almost got up and danced, I was so happy)

Just thought I'd come back and post the solution, in case anyone else ends up finding this thread in the same position I was in.

Now how do I mark this thing solved?
 

Read other 1 answers
RELEVANCY SCORE 46.4

Hi

Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:

https://support.office.com/en-US/ar...ions-EF163677-3195-40BA-885A-D50FA2BB6B68#bm4

https://askdrexel.drexel.edu/app/an...:-change-password-of-a-workbook-in-excel-2007

We're used to Office 2003, so this is a big jump at work for us

Thanks

eddie
 

A:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.
 

Read other 1 answers
RELEVANCY SCORE 46.4

I have a workbook with a lot of linking between the different worksheets and I am looking for a way to protect the tabs from deletion. If the users delete a tab, it will cause many error messages. I would like it to popup a message box stating "Deletion of tabs in this workbook is prohibited" and deny the operation. I have the cells protected and I know that there are workarounds to get around that, but my users are not looking to sabatoge my work - I just want to keep them from deleting a tab without knowing it will cause havoc. I don't know how many ways a tab can be deleted, but I want to cover them all. Thanks in advance for anyone who can help.
 

A:Excel VBA Protection

Hi Dan

I would do it this way: use the Workbook Open event and simply disable the Delete options

Code:

Private Sub Workbook_Open()
With Application
.CommandBars("Tools").Controls("Customize...").Enabled = False
.CommandBars("Toolbar List").Enabled = False
.CommandBars("Cell").Controls("Delete...").Enabled = False
.CommandBars("Ply").Controls("Delete").Enabled = False
.CommandBars("Ply").Controls("Move or Copy...").Enabled = False
.CommandBars("Worksheet Menu Bar").Controls("Edit").Controls("Delete Sheet").Enabled = False
End With
End Sub

Then use the Workbook Close Event to reset: simply copy the above code and change the values to TRUE.

The code disables the 'Customise' option if you rightclick on a toolbar, it disables the 'Delete' and 'Move or Copy' options from the sheet right click menu, it disables the 'Delete' option from the tab right click menu and it disables the 'Delete Sheet' option from the edit menu.

By using the Open Event, these items are disabled as soon as the workbook opens so there is no message box because the user has nothing to click on (if you see what I mean).
HTH

Regards
 

Read other 3 answers
RELEVANCY SCORE 46

The company I work for has a control room where they have to enter data into excel spreadsheets with lots of links and macros, so we password protected the sheet so that they could only manipulate the cells that they needed. Myself and 2 other employees have access to the spreadsheet. Someone changed the password and the person does not remember what they changed it to. Is there any way to reset the password?
 

A:Password protected sheet in excel and can't remember the password

Do you have a backup from before the password was changed?
 

Read other 3 answers
RELEVANCY SCORE 46

I just made a spreadsheet and i have formuals in certain rows i do not want to have changed. I understand to protect things i have to protect the sheet. But becasue some people will be needed to make changes to different variables i need to have certain cells "unlocked" so that they can go in and freely input there info on a weekly basis but not have the ability to delete the forumlas i wish to have locked in.

Can anyone help me please.

Time is of the essence.

Im handing the reigns over on monday.....

Thanks for any and all help.

A:Excel Cell Protection.

Protect the entire sheet. Then unprotect cells you allow to change.

Read other 3 answers
RELEVANCY SCORE 46

I have created a little quiz and locked down the worksheet in Excel, so that the only cells that can be accessed are those in which the answer should be written.

A formula has been set up so that if the answer they provide matches that contained in a cell that i have hidden, then the word TRUE will be displayed.

This works well, and I have locked it down so the answers cannot be unhidden, nor formulae seen. Also there are no scroll bars.

However, if they highlight the whole area (as one brighter one did), then copy, and paste into a new worksheet, the answers can be easily accessed.

a) does this make sense?
b) without VB coding (i have yet to learn visual basic) can I prevent this from happening?

and c)

shall i give up and presume myself to be a pure dimwit ?
 

A:Excel 97 - protection issue

.....Forgot to mention - if anybody would like to see a copy of what I am blabbering on about in order to help diagnose, please mail me.

The file size is only 27 kb

use mail link below...

Thanks
 

Read other 3 answers
RELEVANCY SCORE 46

i have an excel file with 3 worksheets and 4 macros.
the macros combines data from sheets 1 and 2 into 3, and then exports the sheet 3 result as a .prn file. when i try to protect the macro, the save step fails.
 

A:excel macro protection

Hi there, welcome to the board!

Can you describe - in great detail - the exact steps you are taking? What version of Excel are you using? What is the exact error message? Have you ever had this problem before, can we get a little history of this file? If nothing else, can you upload a sample of your file, minus any sensitive information?
 

Read other 3 answers
RELEVANCY SCORE 46

hi all, can anyone help please

basically i have a worksheet that is protected except for the ranges F5:F15,G5:G15,H5:H15 and I5:I15 for data entry, i also have 4 optionbuttons 1 - 4, what i am trying to do is, if optionbutton 1 is selected then ranges G5:G15:I5:I15 become protected so only entries can be made in F5:F15, if optionbutton2 is selected ranges F5:F15 and H5:H15:I5:I15 are protected so only entries can be made in G5:G15 and so on through the 4 buttons i've checked various forums but can seem to find the answer, can this be done or is there a different way to go about doing this, any help with the coding would be appreciated.

scouse13
 

A:excel cell protection

Read other 8 answers
RELEVANCY SCORE 46

STOP PRESS - After i wrote this I went back and had another play and found the 'lock' function for cells which when used alongside the worksheet protection does exactly what i wanted it too !
Ian

****************************************************

A long time ago when i first started using spreadsheets I used a simple package called SuperCalc 4, one of the functions it allowed me to do was 'protect' from change (editing) specific cells, rows and / or columns.

I can't seem to get Excel to do the same, it seems only able to provide crude protection to whole sheets or offer tracking of changes unless of course you know better !

(Just for interest, what I am doing is sending worksheets out to home based staff, on the sheet is information such as client names, tasks visit dates, reports to typing and so on. I want them to be able to input dates and comments but not change client names, tasks and so on. I used to print the sheets and fax them out but we are trying to move into the e mail age now !)

Any suggestions greatfuly received !

Ian
 

A:Excel 97- Protection of data

1. select the whole worksheet
2.choose format,cells to open format cells dialog box
3.click the protection tab and deselect the locked option,click ok
4.now select the range youwant to protect
5.choose format cells again and protection and check the locked box and then ok
6. choose tools,protection,protect sheet and then ok

Now when you go to the cells you will not be able to put info in the areas you previously selected.

hope this helps
 

Read other 1 answers
RELEVANCY SCORE 46

Hi, I have a document that I wish to protect specific cells in. I have done this and whenever I double click or attempt to type in a protected field an error message appears. This is a good thing.

What I want to know is whether or not it is possible to prevent single clicking on protected cells as well. Basically, for the few fields I want data to be allowed to be entered in, I want them to be the only accessible fields. I don't even want to be able to do as little as click on cells other than the few left unprotected.

Is it possible to prevent any form of access, highlighting, clicking, typing on protected cells?
 

A:Cell Protection (MS Excel 97)

Read other 7 answers
RELEVANCY SCORE 46

A user who has a spreadsheet he sends out to people and they fill in data, then return to him. User wants to know if possible to prevent people from entering punctuation marks into the cells, ie so that all you can enter is plain text abcdefgh etc... Sure this is possible via some kind of data validation?but could not figure out how to do it.
 

A:Excel query - protection?

Read other 10 answers
RELEVANCY SCORE 46

I want to protect my formula from being overwritten, but i still need to be able to sort the other files that are not protected in alphabetical order, i have unlocked all the cells on the sheet, then locked and hidden the ones just for the formula, and then I have locked the sheet.
I can insert data into the unprotected cells but if i try to sort them the command for the sort is greyed out.
Is there a way to do what i need, Is it pssible to do it using VBA.

TIA
 

A:help needed with excel protection

Read other 8 answers
RELEVANCY SCORE 45.6

I have windows 2000, I read this article saying that password protection of folders has alway been available Iwent throught this step by step with no sucsess. Am I doing something wrong or is this really not possible.

thanx
 

A:password protection

http://www.jcmatt.com/filebuddy.html
 

Read other 3 answers
RELEVANCY SCORE 45.6

Hello there, is there a way to prevent unathorized access to my pc when, for example, I am downloading a file and I am away from the pc?
I mean something like the standbuy mode but with Kazaa and other programs running.

Thanks in advance
 

A:Password protection

Read other 6 answers
RELEVANCY SCORE 45.6

I am looking for a script or program that will password protect a web directory and re-direct the user to a particular web page based on the user name and password. Does anyone have any suggestions?
 

A:Password Protection

What is the operating system and what is the web server?
 

Read other 3 answers
RELEVANCY SCORE 45.6

does anyone know if there is anyway to put a password on a file on my desktop or any other file on my pc ?

A:password protection

Easier to put it on your whole account.

Read other 3 answers
RELEVANCY SCORE 45.6

I want to password protect a particular folder and its contents. I have tried right clicking and selecting 'Sharing and security' option, followed by putting a check in the box headed 'make this folder private'

All this seems to do however is require me to enter a password at the initial login screen when booting up - but when I click on the actual file I want to protect it is letting me straight in!

Where am I going wrong?
Thanks
jampot
 

A:Password protection

Hi What operating system (version of Windows) do you have? And, if you have XP, give the Service Packs you have installed, if you have just SP1 or SP2.

If you don't know how to find that info, here is a small utility that will help> Do NOT post the entire log it shows you> ONLY post the version of Windows it shows you are using such as Windows XP Home Edition, Pro, or other...and the version of Service Packs you have.

www.belarc.com

Download the free Belarc Advisor which will give you a lot of information on your computer.

It also lists the Windows Updates installed and whether they are installed correctly.

Then I may or someone may be able to help with passwording a particular folder.
 

Read other 3 answers