Display popup box on my pc when any user saves shared excel file
We have a shared excel file where users are login and adding their requirements. if any user saves the file, the next moment i should get the message on my pc as "User 1 saves the file". pl check, if someone help me to implement this more easily.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
follow these steps to password-protect Excel file
Step 1: Save your *.xls Excel file
Point to the File Menu, click save as and input the file name then the *.xls file is saved on your local disc. Point to "Tools" - "Options". When the "Options" multi-tabbed dialog box appears, click the "Security" tab.
Step 2: Choose the password protect type
• If you don't wish other users to view your Excel workbook, enter a password in the "Password to open" box, and then click OK.
• If you agree other users to view your Excel workbook but don't want them make changes to the workbook, type a password in the "Password to modify" box.
• If you wish to use a different encryption settings type, click Advanced, choose an encryption setting type you want in the list, and then click OK. And you can also specify the number of characters in the Choose a key length box.
Step3: Confirm your password
After type your password, a "Confirm Password" box will prompted, retype your passwords to confirm, then click OK.
Step4: Resave the Excel spreadsheet.
After password protecting your Excel file, click Save. All the steps are finished.
This could happen if your workbook is being shared. 1. Make a backup copy of your workbook (Excel file). 2. Open it in Excel 3. Check under Tools > Share Workbook and see if the "Allow changes by more than one user..." option is selected. If so, try unchecking it and save the workbook 4. Check the file size under File > Properties > General tab
Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing Ctrl+End and see where the end of your document is. If it is way beyond your current work area, select those extra columns and rows and go to Edit > Clear > All (Note: This will delete everything on those cells)
1. While saving an excel file, on the save as box, click on "Tools".
2. On the drop down munu, click on "General Options"
3. On the password to Open box, type a password
4. On the password to Modify box, type a password
If you want users to be able to read the file, check the box that says "Read-only recommended."
Users of the Microsoft Office XP and 2003 programs Word, Excel, or PowerPoint—please install all High-Priority updates from Microsoft Updatebefore downloading the Compatibility Pack.
By installing the Compatibility Pack in addition to Microsoft Office2000, Office XP, or Office 2003, you will be able to open, edit, andsave files using the file formats new to Word, Excel, and PowerPoint 2007.The Compatibility Pack can also be used in conjunction with theMicrosoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPointViewer 2003 to view files saved in these new formats. For moreinformation about the Compatibility Pack, see Knowledge Base article 924074.
Note: If you use Microsoft Word 2000 or Microsoft Word 2002 to read or write documents containing complex scripts, please see http://support.microsoft.com/kb/925451 for information to enable Word 2007 documents to be displayed correctly in your version of Word.
Ensure your system is up to date by installing all High-Priority/Required updates on Microsoft Update(required for Microsoft Office XP and 2003 users).
After installing all High-Priority/Required updates with Microsoft Update, download the Compatibility Pack by clicking the Download button above and saving the file to your hard disk.
Double-click the FileFormatConverters.exe program file on your hard disk to start the setup program.
Follow the instructions on the screen to complete the installation.
To remove this download:
On the Windows Start menu, click Control Panel.
Select Add/Remove Programs.
In the list of currently installed programs, select Compatibility Pack for the 2007 Office system and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
Click Yes or OK to confirm that you want to remove the program.
P.S.: If this information was helpful, please rate this solution.
1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.
2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents
3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)
An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.
Whenever Excel closes unexpectedly, "ghost users" can remain in a "shared" workbook. Excel tracks changes in order to synchronize between users, resulting in huge file sizes. In order to fix the problem click Share Workbook (Review tab, Changes group in 2007 or Tools/Share Workbook in earlier). On the Editing tab see if there are any "Users" using the workbook. If so, remove them by clicking "Remove User." When you save again, the file should be back to normal. Being this is a Microsoft product, I want to re-emphasize the word "should" from my previous sentence...