protect excel for mac user can still can hide columns or rowa

Protect Excel User Can Still Can Hide Columns Or Rowa Full For My

What I would like, then, is to have two separate sheets - one with the project data and the budgetary info, and another with just the project data - that do not require manual updating.

If theres a discussion here that interests you and youd like to find (or create) a more current version, please Visit the Current Forums.

Is this possible And is it possible to have the sum of amounts in sub-tasks appear in the cell of the main task.

If you lock the column at the top and hide the cells and viewer cant change the view.

If the person that you are wanting to block is an admin then this wont work.

If you want to have the numbers total to a parent row use the sum formula.

This must be done on individual sheets rather than in a workspace.

This means that any additional rows that are entered also have to be manually updated on the linked spreadsheet.

The existing links will update where informationdata changes, however if you add rowscolumns into the linked sheet then those rowscolumns would need also to be inserted and then linked.

The key to the successful use of linked cells is Planning and Design.

Linking should be one of the last steps and that then should reduce the manual updating.

Hide the columns you do not want them to see, then send them an update request of any rows they need to edit.

They will only see unhidden columns and the rows you selected.

Just be careful with this method - if the columns are not hidden at the time they open the update request, they will see the column (exactly how it currently is in the sheet).

In order to avoid to duplicate the sheets (and link them), I think the best is to have this as an option in the hide properties of a column.

If you want to share a read only version of your data you can send rows (and only include certain columns) or create a report which will only show columns you selected, then publish the report as a read only view.

Im nowadays using the Send Row option which is very good to summarize a topic, Issue to a colleague or customer.

Protect Excel User Can Still Can Hide Columns Or Rowa Full For My

I dont see that usefull for my request.;-( Im looking for something unattended, in a way I just need to setup initially what info to be visible to others for the full project.

Being able to control who can see what columns would be a MAJOR improvement.

Some of the data is autopopulated and some members of our team do not need to see it.

Having the option to hide columns or create custom views would enable us to store all data on one sheet while not cluttering it for those who only need to access half of the rows.

I see people posting that sensitive data such as rankings and budgets should have the functionality to be restricted by user or using some filter.

The report solution only works when users have viewing rights only.

I will not be able to convince management that Smartsheet is a viable replacement for all our project without this functionality.

Protect Excel For Mac User Can Still Can Hide Columns Or Rowa