Every time I try to convert a table to a range my excel sheet stops responding. I use office 365 and I have an apple computer. My data is in a table because I link the data to a spreadsheet. Each month I add a new months worth of valuations. To do that I would have to convert the data back to a range, copy and paste the columns and rows I want to update above the previous months data, change the copied cells to show the current month and then update the valuations. Then I convert it back to a table. Once I refresh the pivot table I can see the new month appear. Is it possible to get automatic updates without using a table? Also, is it possible to use pivot charts with microsoft 365 version of excel on mac computers??
