I am looking for help in finding a way to restrict the user of excel to only edit the text in the cells but retain formatting. The user can update his name, correct spelling etc buy should not change background color or font size and font. How to control these? I am using Microsoft 2010 Excel in compatibility mode. If you can share me snapshots of the controls or at least the steps it will be of great help. One more information is that th contents what user enters will get updated automatically in other sheets of same work book which will be password protected. Thank you

How to load the slides created in Microsoft PowerPoint into HTML page in a server. The user will upload the power point presentation slides and I have to load them, do some processing if required and play a slideshow in the webpage itself. How to play slideshow in webpage in HTML? I have dream viewer tool for HTML design. How to load the slides into multiple windows, but in the same page, if the user prompts for multiple slides to play at once? Thank you for your help

I am using MS project for a project which has more than 120 tasks. I recently refreshed TFS and I can see that the roll up time do sent match with the actual. Since there are so many tasks, resetting the resource allocation is not a viable option. What are the properties of TFS? How should one ideally treat the TFS project? Can I import the TFS data into new project directly? How to refresh and still get the proper roll up time in MS project?

This is my Setup. Windows 7 running on a laptop with Microsoft PowerPoint 2010. I have created a presentation with many pages/ Most of them have tables and graphs. How to select all tables in power point at a time? How to apply various formats such as fonts, size and colors etc to al the tables at a time? I do not want to update the style of all the tables one by one as it calls for more time. How to perform this action? Thanks for your help?

I have a project whose time elapsed component is not acceptable as in this project there are several future activities which are either started or already complete. I also have doubt about tasks which are interrupted. How to consider all these and report percentage completion of entire project? I have base lined the project and I am little confused about the measurement. What are fixed duration tasks and how are they different from normal tasks? What are the changes to be done while measuring the performance of whole project?

Assume there are five people to whom tasks have to be allocated. I want one person to work on a task for complete day or until the task is complete whichever is earlier. How to define this requirement is MS project so that, first person will get to handle the task on Monday, the remaining task will be handled by the second person on Tuesday and so on? I have tried, but since the task almost gets over in two days, the other three persons are not getting the tasks only to be accomplished. What is the solution?

I am managing a very big project with multiple managers for specific task groups. I would like to assign one of the mangers to update the task status. How to set any one of the available several project managers as a manager with rights to update the task status? How to add multiple managers to one single project? What are the permission rights available? Adding the resources is easy thing. But I am worried more here about roles and their permissions.

I have the role of Manger and I am trying to analyze the efficiency of tasks assignment and status of the tasks. If I select one individual task, what should I do to view the efforts of all associated put into that task in one view? Is there a way to create custom group so that I can view efficiency of selected associate in the entire project? What is work filed primarily used for? Does it have anything in store for my requirement? How to use work file?

I am using the MS Project and I am trying to take print out of the calendar with the tasks. I am trying to make all the tasks visible but I can notice that some of the cell data are missing. Is it a known issue while issuing print in MS project? Cannot I get all the tasks printed in one page with current view? What are the optimizations I can do to get all tasks in page printed? What is the best option in setting Layout view?

I am just learning all the things in MS project and want your help in learning the things better. What is the way to add the activity? How to add status information to all the activities? How to issue print to the printer the current view I am looking? How to add risks to activities? What is the way to add approval and rejections? How to set email alerts to pending activities? What are the different available roles? Thank you for your help?