Forum Discussion

杰克逊1300's avatar
杰克逊1300
Copper Contributor
Jul 17, 2023

ANALYSIS IN EXCEL FUNCTION DOES NOT WORK IN SSDT

VISUAL STUDIO 2022 OPENS THE SSAS TABULAR MODEL PROJECT FILE, AND THE ANALYSIS  IN EXCEL FUNCTION DOES NOT WORK, AND THE EXCEL PIVOT TABLE CANNOT POP UP, WHAT IS THE REASON?
Tiago_Meireles's avatar
Tiago_Meireles
Icon for Microsoft rankMicrosoft
Jan 23, 2024

杰克逊1300 Most likely related with corrupted excel installation. Try repairing the office installation (or just excel).

  • steensp's avatar
    steensp
    Copper Contributor
    Jan 25, 2024

    Tiago_Meireles 

     

    That was not the case for me. I tried to reinstall Excel and Office etc. several times. It have started to work again though, and I think that happened after one of the latest updates of Visual Studio 2022. I'm not sure which of the updates, but since that's the only thing I have updated lately on my PC, I'm quite sure that this was the reason.

     

    /Steen