To check if your system is 32 bits or 64 bits go to File Explorer then right click on "This PC" or "My Computer" which ever has been setup on your machine (for older windows called "My Computer" and new windows now called "This PC") and click properties. Look for the "System Type" and it will tell you if your system is 32bit (x86) ior 64 bit (x64) operating system. To check if MSOffice is 32 bit or 64 bit, open your Excel then click File then Account then About Excel. It will tell you if your MSO Excel is 32 bit or 64 bit. To check if P6 is 32 bit or 64 bit, open P6 and click Help menu then About Primavera P6 then select system tab. Look for platform and it will tell you if 32 bit (x86) or 64 bit (x64).
In your case if the Export -> Speadsheet (xls) is grey out and cannot be selected, I suspect that your P6 does not recognise that MSO Excel is installed in your machine. Usually happened if they have different operating system type (32 or 64). Primavera P6 rel 15.x is the first officially release having 64 bit platform. If you have P6 rel. 16.1, you may have either 32 or 64 which may not be compatible with your MSO Excel which is can be solve easily.
Try to repair you MSO Excel installation and it may work. If not try to re-installed the MSOffice so Primavera P6 will recognise that it was installed on your machine. Try the same system platform (32 bit or 64 bit) which ever is Primavera P6 platform is installed on your machine.
Member for
8 years 7 months
Member for8 years7 months
Submitted by Henry George on Sun, 2021-08-15 15:40
Mr.Rodel thanks for your question my P6 Version is 16.1 and its always grey out once i click spreech to export,i dont understand the 32bt you asking please explain morethan if yo can thanks
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Sun, 2021-08-15 02:16
What version of P6 are you using? Is your P6 using 32bit or 64bit? Is your MSOffice Excel 32bit or 64bit? Is the Export -> Spreadsheet - (XLS) not active or grey out and cannot be selected?
Member for
8 years 7 months
Member for8 years7 months
Submitted by Henry George on Sat, 2021-08-14 09:16
Please Good Morning all who will help me with my P6 Settings dunno if i installed it well or not,trying to export to excel has never been possible for me dunno why...same software i have installed in a different computer expoting to excel was easy but now HP-Window 10 i installed but exporting to Excel not working...
Member for
16 years 3 months
Member for16 years4 months
Submitted by Zoltan Palffy on Wed, 2021-07-28 13:45
Rodel has the work around but to fix the underlaying problem can you please post the error that you are receiving whne tryin gto export to and xml file.
Under admin
Global profile
Security profiles
make sure that all of the boxes are checked fro Has privilege
especially the import XML one
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Wed, 2021-07-28 02:11
The reason why you are getting error exporting to XML MPP is you may have some link in P6 that have same Activity ID which maybe a combination of SS & FF or SS & FS or FS & FF, usually common on LOE activities. This violate the rules in MSProject. Make sure this issue has been corrected in P6 before exporting to XML. Make sure when exporting to MPP XML, you use the version of MSProject that you have in your machine.
Another option is use a converter online free XER to MPP or MPX to MPP.
Member for
19 yearsHi Henry,To check if your
Hi Henry,
To check if your system is 32 bits or 64 bits go to File Explorer then right click on "This PC" or "My Computer" which ever has been setup on your machine (for older windows called "My Computer" and new windows now called "This PC") and click properties. Look for the "System Type" and it will tell you if your system is 32bit (x86) ior 64 bit (x64) operating system. To check if MSOffice is 32 bit or 64 bit, open your Excel then click File then Account then About Excel. It will tell you if your MSO Excel is 32 bit or 64 bit. To check if P6 is 32 bit or 64 bit, open P6 and click Help menu then About Primavera P6 then select system tab. Look for platform and it will tell you if 32 bit (x86) or 64 bit (x64).
In your case if the Export -> Speadsheet (xls) is grey out and cannot be selected, I suspect that your P6 does not recognise that MSO Excel is installed in your machine. Usually happened if they have different operating system type (32 or 64). Primavera P6 rel 15.x is the first officially release having 64 bit platform. If you have P6 rel. 16.1, you may have either 32 or 64 which may not be compatible with your MSO Excel which is can be solve easily.
Try to repair you MSO Excel installation and it may work. If not try to re-installed the MSOffice so Primavera P6 will recognise that it was installed on your machine. Try the same system platform (32 bit or 64 bit) which ever is Primavera P6 platform is installed on your machine.
Member for
8 years 7 months(No subject)
Member for
8 years 7 monthsMr.Rodel thanks for your
Mr.Rodel thanks for your question my P6 Version is 16.1 and its always grey out once i click spreech to export,i dont understand the 32bt you asking please explain morethan if yo can thanks
Member for
19 yearsHi Henry,What version of P6
Hi Henry,
What version of P6 are you using? Is your P6 using 32bit or 64bit? Is your MSOffice Excel 32bit or 64bit? Is the Export -> Spreadsheet - (XLS) not active or grey out and cannot be selected?
Member for
8 years 7 monthsPlease Good Morning all who
Please Good Morning all who will help me with my P6 Settings dunno if i installed it well or not,trying to export to excel has never been possible for me dunno why...same software i have installed in a different computer expoting to excel was easy but now HP-Window 10 i installed but exporting to Excel not working...
Member for
16 years 3 monthsRodel has the work around but
Rodel has the work around but to fix the underlaying problem can you please post the error that you are receiving whne tryin gto export to and xml file.
Under admin
Global profile
Security profiles
make sure that all of the boxes are checked fro Has privilege
especially the import XML one
Member for
19 yearsHi Kevin,The reason why you
Hi Kevin,
The reason why you are getting error exporting to XML MPP is you may have some link in P6 that have same Activity ID which maybe a combination of SS & FF or SS & FS or FS & FF, usually common on LOE activities. This violate the rules in MSProject. Make sure this issue has been corrected in P6 before exporting to XML. Make sure when exporting to MPP XML, you use the version of MSProject that you have in your machine.
Another option is use a converter online free XER to MPP or MPX to MPP.
Search online converter!