My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Forum

You are here: Home / Forum
Marc Bergmans
@marcberg
Forum Home   |   Recent Posts
Trusted Member
Joined: Feb 19, 2021
Profile Activity
Topics: 18 / Replies: 5
AllTopicsReplies
Topic
Macro to compare sheetname from one workbook with another and take actions depending if there is a match or not.
3 years ago
Forum
VBA & Macros
Replies: 1
Views: 41
Topic
Oracle Ora-02391 Excedeed simultaneous Session per user Limit when activating a query without an Oracle connection
3 years ago
Forum
Power Query
Replies: 1
Views: 93
Topic
Is it possible to pivot columns without Distinct
4 years ago
Forum
Power Query
Replies: 1
Views: 89
Reply
RE: Uploading Oracle result into Excel Power Query is very slow

Thank you for the answer. I'm trying to use the OLEDB im my query but i don't succeed. I always get an syntax error. The syntax i use is Provider=Ora...

4 years ago
Forum
Power Query
Topic
Sometimes i can do other work in Excel while running a query sometimes not
4 years ago
Forum
Power Query
Replies: 1
Views: 75
Topic
After starting a query with a connection to Oracle the message maximum simultaneous connections to Oracle reached appears
4 years ago
Forum
Power Query
Replies: 1
Views: 31
Topic
Uploading Oracle result into Excel Power Query is very slow
4 years ago
Forum
Power Query
Replies: 3
Views: 87
Topic
Join Queries that collect variables from Excel and will be used in a sql to gather data from an Oracle Database in one query.
4 years ago
Forum
Power Query
Replies: 1
Views: 24
Reply
RE: Automate refresh all Power Excel Queries and Pivot Tables in one Excel Sheet.

Hello Mynda, Is it possible to let refresh everything (queries and Pivot-tables which are built from a table) automated by pressing Data Refresh All....

4 years ago
Forum
Power Query
Topic
Join Queries that collect variables from Excel and will be used in a sql to gather data from an Oracle Database in one query.
4 years ago
Forum
Power Query
Replies: 1
Views: 66
Topic
Automate refresh all Power Excel Queries and Pivot Tables in one Excel Sheet.
4 years ago
Forum
Power Query
Replies: 3
Views: 150
Topic
Question abault Layout Features (format) of Pivot Tables
4 years ago
Forum
General Excel Questions & Answers
Replies: 1
Views: 82
Topic
Default in Data Validation which is built by a table
4 years ago
Forum
General Excel Questions & Answers
Replies: 1
Views: 45
Topic
I don't get subtotals in the power Pivot Table after putting the file in a datamodel.
4 years ago
Forum
Power Pivot
Replies: 1
Views: 57
Reply
RE: Need that in a pivot table the subtotal of column with averages is the sum of the items and not the average.

i'm sorry, i attached the file but i didn't upload it. Now it is hopefully attached.

4 years ago
Forum
General Excel Questions & Answers
Page 1 / 2