I have an issue in Excel 2013; I don't know if it's a bug or a new feature, but my own Googling has got me nowhere, so over to you guys.
In Excel 2013 only, tried in Safe Mode and on several different machines, I cannot get the ODBC previewer to actually preview my field data.
The steps I take...
In Excel 2013 (in a spreadsheet with data links) go to Data | From Other Sources | From Microsoft Query
In this query wizard in previous Excel versions, you were able to press "preview now" and the data preview should appear, allowing you to fault check things easily. Now:
- safe mode doesn't work
- tried on different machines to eliminate the install
- reinstalled Office
- installed Excel 2013 on its own
- occurs in W7 and W8
- occurs on 32 and 64 bit machines
If this was by design, I wouldn't expect the preview to be there. Any ideas, or is this a bug that M$ are working on?