-
I'll see if I can find that option.
I swear my current version of PQ looks more stripped down than it used to. I have also lost the PQ tab like this:
And only have it as option within data (I think).There have been efficiency drives so I wonder if they've scaled back the office package or something. Likewise, I could be paranoid but I think they've reduced the number or processors(?) or something on my VM. My ram is the same but I'm routinely maxing out my machine using xls.
hugo7-
Likewise, I could be paranoid but I think they've reduced the number or processors(?) or something on my VM. My ram is the same but I'm routinely maxing out my machine using xls.
I made a file a while back to benchmark Excel. Runs a macro to generate some random numbers and do some lookups, sumif, etc a number of times and times it.
5 iterations takes about 45 seconds on my work laptop (which is a couple of years old)
aggi
Have you selected based preview on the entire data set rather than top 1000 rows that might help you load more and if you can catenate a number in a text then you have to treat as text I think