User Profile

Judit950

Copper Contributor

Joined May 26, 2022

3 Posts1 Solution

View All Badges

User Widgets

Recent Discussions

Re: Funtion IF
gandriol Hope all is well! This might help: =iF(H14<>"unjustified",0,if(J13<=15,I13*J13,I13*15)). Hopefully this helps but let me know if I have misunderstood anything.
May 30, 2022 Place Excel
1.4KViews
0likes
0Comments
Re: Power Query & ODBC
SergeiBaklan Many thanks for the information! I tried to connect to the binary file via MS Access Database and this seems to have helped so thanks ever so much for the suggestion! 🙂
May 27, 2022 Place Excel
1.5KViews
0likes
0Comments
Power Query & ODBC
Hi Everyone, I hope you are all well! 🙂 I am new to Power Query and I have been trying to load data from an Excel workbook with several tabs / calculations into Power Query via the Data ribbon > Get Data > From File > From Excel Workbook. I then select the excel sheets I wish to transform. After transforming the data, I find launching the Power Query editor is very slow. A such, I wanted to try to use ODBC instead to see if this would be any faster. However, upon selecting the workbook for import under Data ribbon > Get Data > From Other Sources > From ODBC (and selecting the Data Source Name), only tables (in my case the named ranges I created in the source file) were visible for selection and further transformation. The excel worksheets themselves were not visible. As such, can someone tell me 1) Is it possible to connect to excel binary files effectively 2) Is it not possible to transform Excel worksheets in ODBC? 3) If not, how can I make the first method I described above any faster? Many thanks for your help in advance, very much appreciated! Judith
Solved
May 26, 2022 Place Excel
excel
1.8KViews
0likes
3Comments

Recent Blog Articles

No content to show