Results 1 to 4 of 4

Thread: Exporting project information to excel pivot table and workbook

  1. #1
    Join Date
    Dec 2005
    Posts
    80

    Exporting project information to excel pivot table and workbook

    I am new to Microsoft Project 2007. When I opened a project today and then entered some task information in a new file, then I didnt copy for anywhere. So after that I tried to use the file to save as excel pivot table but then got some kind of error that says "You are trying to save a file saved in an older file format. Your settings do not allow you to save the file in older file formats. To change your setting, navigate to the "Security" tab in the Options dialog box." Can anyone tell me how to solve this error? Thanks.

  2. #2
    Join Date
    Oct 2005
    Posts
    449

    Re: Exporting project information to excel pivot table and workbook

    I can easily save the Project 2007 files as Excel files without any problems. The settings that I am using for legacy formats is "Allow loading files with legacy or non default file formats." The .xls setting is an older version and not the 2007 version of Excel, so you could be having that kind of an issue. Have you tried changing the setting in Tools >> Options and then Security? Check that and let us know whether it worked for you or not.

  3. #3
    Join Date
    Dec 2005
    Posts
    80

    Re: Exporting project information to excel pivot table and workboo

    I am using the Excel 2007 and I have changed the settings that you have suggested me and now everything is working fine. Thanks a bunch for your help.

  4. #4
    Join Date
    Oct 2005
    Posts
    449

    Re: Exporting project information to excel pivot table and workboo

    I am glad that you have sorted out the problem, and thanks for the feedback.

Similar Threads

  1. How to calculate filed different in Excel Pivot Table
    By YajasK in forum MS Office Support
    Replies: 2
    Last Post: 10-02-2012, 05:20 PM
  2. How to unpivot the pivot table in excel
    By Raju Chacha in forum MS Office Support
    Replies: 2
    Last Post: 08-01-2012, 03:13 PM
  3. Automatically refresh pivot table on MS excel
    By Genna in forum Windows Software
    Replies: 6
    Last Post: 10-07-2011, 11:13 AM
  4. To convert a pivot table to a flattened table in MS Excel
    By zeemga in forum Windows Software
    Replies: 3
    Last Post: 27-11-2010, 06:48 AM
  5. Pivot Table in Excel 2007
    By NIcaBoy in forum Windows Software
    Replies: 2
    Last Post: 02-03-2009, 03:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,643,340,072.40181 seconds with 18 queries