Stack Overflow
Stack Overflow

Questions tagged [excelquery]

28 questions
3
votes
5 answers

Make combinations using Excel queries

I need to make all the possible combinations(not permutations) with three numbers using excel queries. I have six numbers in a column. From A1:A6. I need to make all the possible combinations(not permutations) with three numbers using excel queries.…
Dinuka W
  • 35
  • 4
3
votes
1 answer

Power Query ignore missing column

I have made a custom function to transform files in a power query: let Source = (#"Sample File Parameter1" as binary) => let Source = Excel.Workbook(#"Sample File Parameter1", null, true), #"Sjælland m# kl# 1" = Source{[Name="Sjælland…
Mikkel Astrup
  • 405
  • 6
  • 18
3
votes
4 answers

Tracking down the source of a dataformat error in a query

I have a query in Excel, retrieving data from a different workbook. Recently, however, the table the query writes data to has failed with the error DataFormat.Error: Invalid cell value '#N/A'.. Going through the steps of the query in the query…
eirikdaude
  • 3,106
  • 6
  • 25
  • 50
1
vote
0 answers

Call a SQL Server using Excel with some time filter

I want to import a live data server from Microsoft SQL Server with time filter but in Excel and a refresh button. To be more exact, I want to create a user friendly program in Excel where you can enter 2 parameter values of time (StartDate and…
Andrei22
  • 11
  • 2
1
vote
0 answers

Trouble handling Expression.Error: Column in Power Query

I use Power Query to bring the figures from 24 excel file that are stored in SharePoint in different folders, the files had the same structure, the sheets contains my data source hasn't "header",so all file starts with data (in order to avoid having…
Alisima
  • 11
  • 2
1
vote
1 answer

Excel Query (find all + value of another cell in relation to results)

I need to search ALL cells for a value (VALUE A) and then output the value of all cells 7 cells above that contains the value (VALUE A). For example, if I search for V01 in the screenshot attached, I want to see the results "Crème Fraîche 326 µg"…
Frank Braun
  • 11
  • 1
1
vote
1 answer

How to import multiple csv files into querie connections in Excel?

I would like to import data in Excel from CSV files (they have the same format) using VBA to Loop data importing and formating with Queries. My first goal would be to create the connections from the files in the selected folder. I have the following…
Myro
  • 13
  • 2
0
votes
1 answer

Web Query missing css elements in the table

I using a web query on the NCSL Excuse Absentee Voting Table (https://www.ncsl.org/elections-and-campaigns/table-2-excuses-to-vote-absentee). The table uses this element to mark cells that I would like to show as true:
    …
VivM
  • 1
0
votes
0 answers

VBA add Query via CSV with Formula let: replace value

I have this CSV: columns: "Replace Column 1" and "Replace Column 2" need to be replaced "," to "." in addition, i need to open the file with UTF-8 encoding. How do I open a CSV with this transform of the data? is it possible to do it without…
Kobe2424
  • 147
  • 7
0
votes
1 answer

Lock Structured References to column names in Excel-formulas when data Query is updated and refreshed

I use references to other columns in my table with the following formula: =TableName[@[ColumnHeaderName]] And use the following as a Table array: TableName[[#All];[ColumnHeaderName]] (this is used if I want to make a HLOOKUP to a specific cell given…
Emil Olesen
  • 1
  • 1
0
votes
1 answer

Refreshing Excel Queries with Task Scheduler

I am trying to automate Query refresh in MS Office Professional Plus 2016. I have a cmd script which runs vbs script which runs Excel macro. Everything works if I run it manually. The problem occurs when I set up Windows Task Scheduler and select…
user19232952
0
votes
1 answer

How to prompt the 'access web contact' popup window when opening excel file

I want to prompt the 'access web content' popup window when anyone opens my excel file, so people can use choose their own settings. At the moment it isn't giving the option to chose your permissions - I need the prompt to open when the file opens,…
Rebecca
  • 69
  • 1
  • 2
  • 11
0
votes
1 answer

Why does my excel query return a stack overflow for some people and not others?

I have a power pivot excel dashboard with pivot charts. I obtain the data by using the jira REST API to the source, and the query is scheduled. I have tested access to the dashboard with my colleagues. For 2 people it returns a stack overflow error…
Rebecca
  • 69
  • 1
  • 2
  • 11
0
votes
1 answer

How to make a Query to write cell value based on content of another spreadsheet on GoogleSheets?

I've two spreadsheets and I want write the values of a column based on the values of another columns. On the master spreadsheet I've two columns of interest: 'Ativo' and 'CNPJ'. On the second spreadsheet called 'CNPJs' I've the two columns called…
Augusto
  • 3,825
  • 9
  • 45
  • 93
0
votes
1 answer

Is there a way to bypass basic authentication in an Excel query?

I have an excel file, I get data from web, using API. My data returns in json format. I schedule my query in 'query' and 'properties' so the data updates frequently. I need to be able to share my file with people around my company, but when they try…
Rebecca
  • 69
  • 1
  • 2
  • 11
1
2