O
Out2lnch
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?
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?