Hi Guys,
I thought I'd post a reminder of the cure to this problem. In case someone else searches for it. It was the bane of my existence yesterday.
If your query or table has more that 65000 you can only export it without formatting. And you may have to create a new file name (it doesn't seem to appreciate copying over the top of an old file).
Export it without formatting, and as an xlsx or csv file, and all your data will show up.
I thought I'd post a reminder of the cure to this problem. In case someone else searches for it. It was the bane of my existence yesterday.
If your query or table has more that 65000 you can only export it without formatting. And you may have to create a new file name (it doesn't seem to appreciate copying over the top of an old file).
Export it without formatting, and as an xlsx or csv file, and all your data will show up.
