Forum Discussion
Excell Changed after Update version 1703 for Windows 10 - Not Happy
Hi Aaron,
To prevent creating the table uncheck in File->Options->Data the option "Prefer the Excel Data model...":
Alternatively, when you import text file
on final stage you most probably see like with checked "Add this data..." and when it creates the table
Just uncheck it
and your data will be imported in "old style", without the table
Hi Aaron,
To prevent creating the table uncheck in File->Options->Data the option "Prefer the Excel Data model...":
Alternatively, when you import text file
on final stage you most probably see like with checked "Add this data..." and when it creates the table
Just uncheck it
and your data will be imported in "old style", without the table
I have to agree that this change to importing data is very, very poor. I was totally unaware of the change and so when I followed the fairly intuitive steps to import the data I found that I could not create a graph - I thought that I had gone mad!!
Whilst I would not claim to be an expert, I thought I was reasonably proficient, but now when I try and create a graph all the data went into the Chart title. I tried selecting the data, moving the highlighted areas, changing the format, design, etc., but I could not seem to get any of the data into the graph. Finally, I just clicked on my .csv file and opened Excel directly and found that I could create the graphs as normal. Then I saw this post and thread and now see how to import the data, but really this has been terribly implemented. What sort of users did you try it out on first? My I suggest that you need to involve a much more diverse group?
I still don't understand why I can't create a graph from my data imported the 'new' way, and I can't see why you have made the change. Very frustrating.
Hi Dominic,
I guess i understand you but can't agree.
1) I guess Microsoft has a lot of feedback before introduce any changes to wide range of users, and they hear it. That's user voice, insiders fast ring, insiders slow ring, forums like this. Only after that O365 current channel, then deferred channel, after that not subscribers.
2) The question to shift fully on new connectors or not was discussed in particular on this site few months ago. Final decision is to keep legacy connectors in parallel, you always may use them.
3) G&T (new connectors) is much more powerful tool compare to legacy connectors. Yes, it requires to update a bit the skills to use them, but that's usual story with any new technology.
4) As for your particular case the only thing to do is to remove first (empty) row and after that promote first row as the header, when you may build your graphs without any problems. In general above is done automatically if proper settings are ON in query options. However, you have to have at least some initial knowledge how to work with new queries.
In brief, new queries are not poor things, they are quite powerful things, but we have to know how to cook. Legacy connectors are just small subset of new ones from functionality point of view.
Hi Sergei,
Firstly, thanks for your original reply to Aaron which I found very helpful in getting round the problem.
Whilst I appreciate that lots of additional features have been added and software will obviously evolve, I have to disagree with the implementation (not that it has been added, but how it it has been added) of the data import. I would guess that the vast majority of users don't come to these forums until they have a problem, hence a discussion on this site doesn't reach the majority (until they have a problem).
From an engineering perspective there are a lot of us who use equipement that generates csv files and we manipulate these in Excel. The new 'queries' might well be very useful, but it should be clearer to the average user how to implement them is all that I am saying.
If you want to use a cooking analogy it is like putting sugar in the salt pot and not telling anyone, they just wonder why everything tastes wrong! Sugar is good, salt is good, but you want to know which you are using :-)
Dominic, with this I agree, lack of information is the main issue. People don't go on forums and What's New button is not quite informative even if someone clicks on it after the update.
Perhaps for such particular case that was worth to add the balloon on first using of new connector which informs the legacy connector is still here as well; or something like this.