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


Viewing 1 reply thread
  • Author
    • #46227
      Dan Gravell

      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

      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.