Hello All, I have software which generates Excel 2007 shared workbooks - I cannot change how this software exports the excel file. How do I remove the 'Shared' status of the workbook now? I have a client who I am assisting. Sharing workbooks often leads to merging of changed worksheets. When can excel workbooks be shared? Hi Marian, I believe this is somehow related to using different versions of Excel to access the same file. Gord On Tue, 25 Aug 2009 16:06:52 -0500, Bob I wrote: R-click a Worksheet tab, select All Sheets then OrbExcel OptionsAdvancedDisplay Options for this worksheetUncheck Show Gridlines. Your last post reminded me of a previous post I had commented on: And here is another topic which I found during my work on the last one: Possibly the solution is to save the file as a newer version, and maybe also upgrade the users' versions of Excel? I completely understand the 2003+ environment we have every flavor of office and windows under the sun it seems like and every time I think I have seen all the variations I see something new.
People's photos or initials will pop up to show you who is editing the spreadsheet and different users' edits will be highlighted in different colors. I would recommend starting with killing all current sessions with the file in question. If the program asks which version of Excel to use, choose Excel 2016. Hi Jesse, You can try the following steps to add the option back to your ribbon and check if you can remove sharing: 1. Create a new shared workbook to see if the issue occurs. Actually they aren't using the same version of Excel, there are also 2007 versions, however the extension was chosen due to the 2003 involvement. The Quick Access Toolbar is the bar of small buttons at the top of the Excel window, to the right of the Save button.
I've come across a few of these myself and nobody ever remembers the password, which leads to me cracking it. For example, you may need to turn off the Shared Workbook feature, or you may be in the middle of using the feature. There are 2 - 3 users using it, but not at the same time. To get started, log in to Microsoft OneDrive, OneDrive for Business or a SharePoint Online library using your Web browser. This can be beneficial to other community members reading the thread.
Hello, Could you please help me with the following issue? Provided there are no other users accessing the workbook, you should go ahead and click on Yes. I always advise users to not use the shared workbook feature to begin with. Cause: This behavior occurs if you try to view a project that is in a shared workbook. Could show me how to do with your code? Gord On Tue, 25 Aug 2009 16:06:52 -0500, Bob I wrote: R-click a Worksheet tab, select All Sheets then OrbExcel OptionsAdvancedDisplay Options for this worksheetUncheck Show Gridlines. Hi Marian, Instead of buying more Office licenses, another option is to install the Office Compatibility Pack. You are risking loss of the entire workbook due to corruption and edit conflicts may result in unexpected data to be saved.
Up to three images may be included in a comment. We've removed them because there's a much easier and better way to share workbooks, and that's with. When an excel workbook is shared, each time an user saves the shared workbook, he is prompted with the changes that other users have saved since the last time that he saved the shared workbook. Click Advanced and select the track changes and update features you want to use. You may be able to use this if you or someone you want to work with doesn't have a version of Excel that supports the current co-authoring feature. This leads to a password cracking tool, or someone jumping ship and you lose all knowledge and capability of this file or at least time trying to crack it. So maybe it would help to upgrade this one computer to Office 2007.
Dear all Is it possible to prevent user not to turn off shared workbook? Make sure you choose commands from All Commands, scroll down to find Share Workbook, then add it to a new group of your ribbon. Description: This problem can occur if the file is saved to a network location and then configured as a shared workbook. In the dialog box, type the email addresses of people you want to share the Excel document with, separated by semicolons. After the file was unlocked, I have removed the protection, but after some time it repeated. At one time, people would share Excel files and other documents by emailing them back and forth or coordinating times to open them on a shared drive.
Once you're connected, upload your spreadsheet document and click the file once it appears in the online system to open it. LibreOffice, a free office software suite, also has a mode that allows multiple users to work on versions of the same spreadsheet in its Calc spreadsheet program, then resolve their changes. When they're done, you merge the data from the copy back into the original. I'll try checking the open sessions, but most probably will not work as the users turn off their computer at the end of the day, so most probably the sessions are closed anyway. Upon experiment, I found Excel 2003 works the same way.
Best regards, Rex Zhang TechNet Community Support. However when other staff open it, only filtering is showing for Columns A-K. I'd like to add my 2 cts. OrbExcel OptionsAdvancedDisplay Options for this worksheet. It is not an issue of some user not closing the file properly.
Excel 2010, Excel 2007, Excel 2003 Add or change data validation You can use data validation when you type new values Excel 2013, Excel 2010, Excel 2007, Excel 2003 Create or change charts or PivotChart reports You can view existing charts and reports Excel 2013 Insert or change pictures or other objects You can view existing pictures and objects Excel 2013, Excel 2010, Excel 2007, Excel 2003 Insert or change hyperlinks You can use existing hyperlinks Excel 2013, Excel 2010, Excel 2007, Excel 2003 Use drawing tools You can view existing drawings and graphics Excel 2013, Excel 2010, Excel 2007, Excel 2003 Assign, change, or remove passwords Assign, change, or remove passwords Excel 2013, Excel 2010, Excel 2007, Excel 2003 Protect or unprotect worksheets or the workbook You can use existing protection Excel 2013, Excel 2010, Excel 2007, Excel 2003 Create, change, or view scenarios None Excel 2013, Excel 2010, Excel 2007, Excel 2003 Use the Text to Columns command None Excel 2013 Group or outline data You can use existing outlines Excel 2013, Excel 2010, Excel 2007, Excel 2003 Insert automatic subtotals You can view existing subtotals Excel 2013, Excel 2010, Excel 2007, Excel 2003 Create data tables You can view existing data tables Excel 2013, Excel 2010, Excel 2007, Excel 2003 Create or change PivotTable reports You can view existing reports Excel 2013, Excel 2010, Excel 2007, Excel 2003 Create or apply slicers Existing slicers in a workbook are visible after the workbook is shared, but they cannot be changed for standalone slicers or be reapplied to PivotTable data or Cube functions. But nowadays, you can use Excel with multiple users simultaneously assuming everyone's using a modern version of the software. She has a shared workbook with 5 other staff. Click Share Workbook in the Review tab. Upon experiment, I found Excel 2003 works the same way. I thought this spreadsheet originated from 2003? Description: The process works like this: You share a workbook, and as part of sharing, you save the workbook. Workaround: You cannot view a project in a shared workbook.
However, you cannot create new sparklines, change their data source, or modify their properties. Gord Dibben wrote: You don't. Hi, Make sure all the Office programs have been up to date. You can find more details in these articles: , Regards, Joanne. You turn them off one sheet at a time. Begin editing the document in the online window.