June 25, 2016
I created a power query on my machine and got it working perfectly. I took it to a co-worker's machine and set it up, and two of the steps within the query will not work on her machine. I have had our IT department uninstall and reinstall MS Office -- which they have done three times now on her machine. The last time the installed the 64 bit instead of 32. We've compared versions and Com-Add-ins, but we are still unable to get this working.
This is the two lines of code from advanced editor that breaks on the other machine:
#"Promoted Headers" = Table.PromoteHeaders(Government_Sheet, [PromoteAllScalars=true]),
#"Added KSSN" = Table.AddColumn(#"Added DedCode", "KSSN", each Text.Start([SSN],3) & "-" & Text.Middle([SSN],3,2) & "-" & Text.End([SSN],4)),
The first errors saying that only one argument was expected and two were provided. I can delete this step on her machine and insert the step of manually promoting the headers and it will work.
The second errors saying that Text.Middle is not recognized. I've read that there is another function that might replace this one as well. However my biggest issue is that I don't want to have to modify the code on every machine this may be placed on. Has anyone else experienced similar problems and is there a fix for these issues?
As always, I appreciate the help of this community.
July 16, 2010
It may be that the version of Power Query needs updating. Uninstalling and reinstalling doesn't necessarily mean the latest updates have been applied. See here for version updates. Use the menu on the left of that page to choose the version of Excel you have.