|  

» Sharing and Allow Users to Edit Changes in Excel 2007

CATEGORY - Excel Editing VERSION - Microsoft Excel 2007
To share a workbook with other users:

1. Select Review -> Share Workbook (in Changes Group).
2. Select Allow changes…and click OK.



To protect sharing:

Select Review -> Protect Sharing (in Changes Group).

To allow users to edit ranges:

Select Review -> Allow Users to Edit Changes (in Changes Group).



To track changes:

Select Review -> Track Changes (in Changes Group) -> Highlight Changes.



Rate This Tip
12 34 5
Rating:     Views: 3104
Re: Sharing and Allow Users to Edit Changes in Excel 2007
ejb2307
I was trying to make use of your example, but then I was confronted with an error.

I have a workbook who receives (planning)data from an external connection with an Access query. Somehow I am not allowed to share this with other people on the network.

What am I missing here?

Please help me understand what I am doing wrong...

Thx,

Ernst-Jan
Re: Sharing and Allow Users to Edit Changes in Excel 2007
martindwilson
ejb2307 please post this in the excel 2007 forum
but fyi i dont think you can share and run web queries
[url]http://office.microsoft.com/en-us/excel/HP100968331033.aspx?pid=CH100648821033[/url]
Click here to post comment
For Registered Users
Name
Comment Title
Comments