巴黎人|网址

                                      Tips on using this forum..

                                      (1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

                                      (2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

                                      Printing the Resource Usage Spreadsheet

                                      10 replies [Last post]
                                      Tim Breeding
                                      User offline. Last seen 9 years 38 weeks ago. Offline
                                      Joined: 11 May 2009
                                      Posts: 19
                                      Does any one know how to print the resource usage spreadsheet?

                                      Replies

                                      Zoltan Palffy
                                      User offline. Last seen 48 min 19 sec ago. Offline
                                      Joined: 13 Jul 2009
                                      Posts: 2694
                                      Groups: None

                                      Patrick has the solution and detailed instructions

                                      Patrick Mullen
                                      User offline. Last seen 1 week 3 days ago. Offline
                                      Joined: 15 May 2020
                                      Posts: 10
                                      Groups: None

                                      I believe there are two ways of handing this:

                                      Solution # 1:

                                      Step 1: Activate the "Resource Usage Spreadsheet" to show on bottom:

                                      7406
                                      resource_usage_spreadsheet.jpg

                                      Step 2: Make sure to include the "spreadsheet" option under the print setup. You must make sure to do step one or else the "spreadsheet" option will be greyed out.

                                      7407
                                      print_options.jpg

                                      Solution # 2:

                                      Go to "Resource Assignments" to view the resource assignments spreadsheet. Then print that page.

                                      7408
                                      resource_assignments.jpg

                                       

                                      John Reeves
                                      User offline. Last seen 15 hours 54 min ago. Offline
                                      Joined: 10 May 2013
                                      Posts: 65
                                      Groups: None

                                      This guys issue was never solved and I have the same problem.  You might not know why it is not coming up as directed, but it isn't.  I can copy all and paste to excel and make an excel graph but it seams pretty reasonable that is should be that hard to print a simple graph.  Original problem - there is no selection choice for spreadsheet - only this:

                                      There is not box for spreadsheet under the options menu in page setup.

                                      Only:

                                      Print > Icons (check box) and Grid Lines (Check Box)

                                      And

                                      Page Settings > Break Page Every Group (Check Box)

                                      Anyone know what’s wrong?

                                      Arnold Puy
                                      User offline. Last seen 5 years 18 weeks ago. Offline
                                      Joined: 25 Apr 2007
                                      Posts: 1147
                                      Hi Tim,

                                      In Activities Workspace, select Gantt Chart in the Toolbar and follow my post #2.

                                      Regards,

                                      Arnold
                                      Tim Breeding
                                      User offline. Last seen 9 years 38 weeks ago. Offline
                                      Joined: 11 May 2009
                                      Posts: 19
                                      That really doesn’t cover it all. What I found is that you have to have the Gantt Chart turned on in order for the proper options to show up in the Page Setup menu.
                                      Arnold Puy
                                      User offline. Last seen 5 years 18 weeks ago. Offline
                                      Joined: 25 Apr 2007
                                      Posts: 1147
                                      Hi Tim,

                                      The reason why you have that box in the page setup options it is because you select the "Activity Table" in the Activities Window.

                                      Just follow my post #2.

                                      Regards,

                                      Arnold
                                      Tim Breeding
                                      User offline. Last seen 9 years 38 weeks ago. Offline
                                      Joined: 11 May 2009
                                      Posts: 19
                                      There is not box for spreadsheet under the options menu in page setup.

                                      Only:

                                      Print > Icons (check box) and Grid Lines (Check Box)

                                      And

                                      Page Settings > Break Page Every Group (Check Box)

                                      Anyone know what’s wrong?
                                      Dieter Wambach
                                      User offline. Last seen 3 years 7 weeks ago. Offline
                                      Joined: 15 Jan 2007
                                      Posts: 1350
                                      Tim

                                      Just by coincidence, two ways for the same result.

                                      Regards
                                      Dieter
                                      Dieter Wambach
                                      User offline. Last seen 3 years 7 weeks ago. Offline
                                      Joined: 15 Jan 2007
                                      Posts: 1350
                                      Tim

                                      You’ll open the speadsheet in the view "Activities".

                                      Then File --> Print Preview --> "Page Set-up" (the icon in the upper left corner) --> "Options" --> mark "spreadsheet"

                                      Regards
                                      Dieter

                                      Arnold Puy
                                      User offline. Last seen 5 years 18 weeks ago. Offline
                                      Joined: 25 Apr 2007
                                      Posts: 1147
                                      Hi Tim,

                                      Follow the following steps.

                                      1. Go to view --> show on bottom --> resource usage spreadsheet.
                                      2. At the left bottom corner of your monitor, select any resources you wanted to show.
                                      3. At the center bottom of your monitor, you can customize the column.
                                      4. At the right corner of your monitor, you can select the spreadsheet field whether budgeted, remaining or actual units/cost.
                                      5. When done, go to file --> print preview.
                                      6. Select the page setup button --> options, untick all the the check box and tick only the "spreadsheet.

                                      You can now print only the available resource usage spreadsheet.

                                      I hope this helps.

                                      Regards,

                                      Arnold

                                                                          Application Essentials

                                                                          Finance

                                                                          Blog

                                                                          Mobile Games

                                                                          constellation

                                                                          car

                                                                          aviation

                                                                          search for

                                                                          city