Forum Discussion

cnunez's avatar
cnunez
Copper Contributor
Mar 14, 2025

Pivot Tables

Hello all,

For some reason, I cannot create PIVOT tables anymore, and I am not sure why. I am using the online version of Excel, on Microsoft Edge. When trying to pivot my data, it will with show up blank, or not at all. Does anyone know how to fix this issue? Please see attached photos..

 

  • I had soimething as on first screenshot if entire sheet is select, but on previous build of Excel for web (current one is 16.0.18712.42305).

    For the second screenshot if you stay on A1 it shall suggest to organize your data (empty row after the header). Perhaps on previous build shows nothing, not sure.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

    What happens if you select just a single cell (say cell A1) inside your data?

    • cnunez's avatar
      cnunez
      Copper Contributor

      Hello, Just tried it out, the same thing happens unfortunately.

       

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor

        Strange! Can you share a sample file which exhibits this issue? Make sure it doesn't contain any sensitive information

Resources