Dec 02 2019 05:47 AM
In Excel 2016 I have the following issue;
Since last week I cannot make new queries. Older Excel sheets with excisting queries work fine.
I can start making a new query it looks al fine until it starts loading the data. It counts till the maximumnumber of records but does not actually load, the cursus keeps indicating that it is trying to load.
I tried loading to table, just connection, with and without adding to the datamodel. Updating Office, restarting the computer, nothing seems to work.
Please help!
Dec 02 2019 07:46 AM
It looks like a bug for 2016, I've see few such cases mentioned but never seen the solution. I'd suggest at least to send a frown form Excel.
Dec 02 2019 07:51 AM
Dec 03 2019 07:52 AM
Dec 03 2019 07:54 AM
@Abiola1 but never an solution I suppose?
It drives me crazy and costs a lot of time, even the Microsoft helpdeks couldn't help me. The called it a user specific problem.
In the mean time I already repaired, scrubed and reinstalled but the problem is still there.
I very much hope someone can provide an sollution soon.
Dec 03 2019 01:28 PM
I don't remember there it is exactly in 2016, check for the icon like this
I for the issue itself I read myself about one case and heard from people about few other cases. My guess that's very few and bug appears in some specific condition. Safe mode, reinstalling of the Office with full remove doesn't help. Most probably that is the conflict with something in Windows environment. You may check if you have someone near you with exactly the same Office but bit different other software under the Windows.
But above is only my guess.
Dec 04 2019 07:52 AM
@Sergei Baklan I've never seen that icons in Excel
Thanks for suggestions, I'l look what the resullt is if I remove some recently added add-ins etc.