I have a report in Excel which takes the form of a pivot table. The data source for the table is a query in an Access database. This has worked fine for several months, but today when I tried to refresh the table it caused Excel to crash. I then tried to rebuild the report in a fresh file. Query seems to return the data from Access to Excel ok, and I can construct a pivot table using just the data in the original Access query. However, when I try to create a calculated field (eg - "=if('System Qty'=0,0,'List Rev'/'System Qty')" excel crashes instantly.
Any ideas?
Any ideas?