Skip to Content
avatar image
Former Member

Excel does not recognize Crosstab


Hi All!

I was creating a file with twelve crosstab, Saved it and closed it, now when I open the file it does not recognize any crosstab and I can't work with them anymore, but It happens only to that file, if I open another one the crosstab work just fine.

On attached file you'll it appears on blanks all the "display" options. how can I fix that?

Please help!

Thanks!

crosstab.png (188.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 04, 2015 at 10:19 AM

    Which version of Analysis Office are you using?

    What Excel version?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Luis,

      Did you ever figure this out? Did you try selecting the components tab and
      then selecting the reset datasouce option when you right click on your
      datasource?

      Regards

      Michael

  • avatar image
    Former Member
    Jan 05, 2015 at 10:39 AM

    Hi Jose,

    It sounds like a known error since already 1.3.x versions:

    http://scn.sap.com/thread/3410727

    http://scn.sap.com/thread/3545546

    Unfortunately the root cause is still unclear and it will not be "solved" by 1.4.10 :-(

    If you can reveal the secret I would really appreciate it *g*


    Best regards,

    Martin

    Add comment
    10|10000 characters needed characters exceeded