Hi there,
We have a couple of issues here regarding exporting data from QV to Excel.
1. The issue that QV is exporting in BIFF format so Excel is always opening in compatability mode so we're getting multiple sheets open up if we have more than 65k records (which we often do). Has anyone heard if this is likely to get fixed?
2. When the data is exported, excel cannot sum it correctly. We've verified the data in QV 'to death' so we are 100% confident in the data, but when we export it it often cannot sum the detail correcty. Has anyone come across this before?
Thanks,
Andy.