Go to Forum Home PHPP, SAP & Software Variant sheet in Excel 2010

Tagged: 

Viewing 1 reply thread
  • Author
    Posts
    • #46227
      Dan Gravell
      Participant

      Has anyone successfully opened the variant sheets in Excel 2010? I’m trying to open one of the .xlsm sheets to follow the steps in the PHPP manual (converting a non-variant PHPP to variants).

      When I open the .xlsm file I get the message:

      Excel found unreadable content in PHPP_V9.6a_EN_Variants_Empty.xlsm. Do you want to recover the contents of this workbook?

      If I click yes it whirrs then gives me a message:

      Excel was able to open the file by repairing or removing the unreadable content.
      Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))

      But then the VBA isn’t available to copy and paste into the target PHPP file! The Visual Basic link is grey-ed out.

    • #46228
      Dan Gravell
      Participant

      Ignore me; didn’t have VBA installed! Hope this helps someone else.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.