I have developed a weekly report format in Excel 2007. There are 12 other offices that must submit information for the summarized weekly report that I do. I sent each office a copy of the spreadsheet with all the appropriate formatting already set up, and thought they could simply complete it each week with new information, send it on to me via email, and I could consolidate all into my one report. It isn't working very well - somehow the formatting gets changed in the individual reports, and my summary report just is a pain. Is there a way to lock the formatting on my spreadsheet, while still allowing individual offices to input actual text.
Bookmarks