Share via

Pivot table won't open

Anonymous
2023-11-01T15:55:19+00:00

I am creating a spreadsheet in Excell. I try to open a pivot table but each time, it comes back with a " Can't Conect with Server " message. My internet is fine and it has been doing this to me for the past five days. Why won't it connect?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-11-01T17:49:02+00:00

    Hey there, my name is Ajibola and I'm excited to help you today!

    Make sure your Excel file is saved in a compatible format. If you are using Excel 2010 or later, you should save your file as a .xlsx or .xlsm file, not as a .xls file. If you are using Excel 2007 or earlier, you should save your file as a .xls file, not as a .xlsx or .xlsm file

    Make sure your pivot table is not corrupted or damaged. If your pivot table is corrupted or damaged, you may not be able to open it or connect to the server. You can try to repair your pivot table by going to File > Options > Trust Center > Trust Center Settings > Privacy Options >Clear the Office Document Cache. You can also try to create a new pivot table from scratch by going to Insert >PivotTable.

    If you have any further questions or need additional assistance, please feel free to ask. I'm here to help!

    Give back to the Community. Help the next person with this issue by indicating if this reply solved your problem. Click Yes or No below.

    Kind regards

    Was this answer helpful?

    0 comments