Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

6
votes
0answers
110 views

How to create a Call Diagram for Excel macros?

I have an Excel file with multiple VBA-Macros. For documentation purposes I want to create a UML Call Diagram, or similar that represents which macro calls which other one. Is there a way to ...
5
votes
0answers
1k views

Excel 2013, can data be re-sorted automatically?

Is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically ...
4
votes
0answers
30 views

Use functions like Countif, Countblank etc. to refer to discontiguous ranges.

Is there a way to use array formulas or some other feature to essentially have an excel function that means. =Countblank({A1,A4:A6,A112:127,B29:B38}) etc. Essentially, I want to refer to multiple ...
4
votes
0answers
356 views

Excel VBA : SQL query handles error

I have SQL that I can use in Excel 2013 to get the info from the Access database and it works using the SQL directly in a connection, but now I want to run it from VBA instead so I can use some ...
4
votes
0answers
240 views

Can I modify Excel Online share URLs to open to a specific worksheet?

When I generate a share URL in Excel Online, it takes the following form: https://onedrive.live.com/view.aspx? resid=<DOCUMENT ID>& ithint=file%2cxlsx& app=Excel& ...
4
votes
0answers
1k views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
4
votes
0answers
624 views

Create line graph with embedded horizontal histogram

How do I create these kinds of graphs: with the horizontal histogram counting the number of times the left graphs go through a certain range? I have access to Microsoft Excel and R.
3
votes
0answers
1k views

Excel 2007 - cannot open the clipboard

Every now and then within Excel when I do Ctrl-x (cut) or Ctrl-c (copy) I get the pop-up message 'Cannot open the Clipboard'. I can't see any particular pattern to it but it's very annoying when it ...
2
votes
0answers
21 views

Looping through master sheet and filter out rows that are needed

I have created a script which I want to allow a user to select a file (Master File) and if a condition is a met I want to Copy the data to the excel workbook (which the script is run on) The code ...
2
votes
0answers
38 views

Use Excel to match data from a cell on a worksheet, then copy data from its neighboring column and paste on a different worksheet

I have a spreadsheet with multiple names and phone numbers next to them in each Sheet 1 - Sheet 5. Each Sheet has about 900 names on column A and their associated phone numbers next to them on column ...
2
votes
0answers
36 views

Excel “Smart” Dropdown / Data Validation

In Excel, is there a way to create a dropdown menu or data validation field that Allows the user to enter a value that is not currently on the list (like a combo box) Save that value in the dropdown ...
2
votes
0answers
38 views

How to enable macros on an external hard-drive

I have an external hard-drive that I have mapped locally to the e:\ drive. There is a subfolder that contains Excel sheets with macros that I am unable to run. In File->Options->Trust ...
2
votes
0answers
58 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
2
votes
0answers
131 views

Append values to Access table from Excel with ID autogenerated

I have an Access database with some tables which get updated daily with some values. I need the tables to have an ID field which is auto-generated when the other values of the table are imported from ...
2
votes
0answers
46 views

Pivot Table Slicers. Can I ensure one specific item is always selected?

I'm using Excel 2013. As in the title, I have a slicer (connected to a pivot table and pivot chart) and I'd like to make sure one specific item in my slicer is always selected whilst allowing ...
2
votes
0answers
50 views

VBA Editor title bar buttons show up oddly large

In VBA editor, there are buttons on the menu bar associated with objects like sheets, modules, forms, and classes. The buttons are the minimize, restore, and close buttons in the top right. They only ...
2
votes
0answers
77 views

How can I publish excel workbook with data populated using PowerQuery to SharePoint or website and have the data refresh on the site?

I have an Excel Workbook that gets data from an API using PowerQuery, to populate the tables. There are also filters and slicers in the workbook. Is it possible to publish this workbook to ...
2
votes
0answers
271 views

Microsoft Excel to SQL using Pentaho: syntax error in 'OPTION SQL_SELECT_LIMIT=DEFAULT'

I've been using Pentaho Kettle version 5.1 to transfer Excel data to SQL by following these steps (answered by Edgar): Launch Pentaho Kettle. (Typically) click on 'No Repository'. Create a ...
2
votes
0answers
64 views

Excel: An indication that a small cell contains more information within that cell

When a cell contains more information than the width of the cell allows, then content is hidden. Is there any way to show this visually in Excel that this is the case (like an icon or similar)?
2
votes
0answers
178 views

Excel 2010 not inheriting regional settings from Windows 8.1

In regional settings of Windows 8.1, I have negative numbers set to display in accounting mode. e.g. (1.0) instead of -1.0. Excel should be getting this setting as a default now, as it did in Windows ...
2
votes
0answers
439 views

Different icons for different excel files

In my work, all coding can be done in VBA only - hence, all of our tools (dbase queries, data processing, cash overviews, etc) are written as xlsm files. At the moment, the number of different tools ...
2
votes
0answers
544 views

Add custom error bars to multiple series in one graph

I have my data in a csv file like below, except with more columns and rows Mean values 61 43 Sample 1 0.009 0.059 Sample 2 0.108 0.099 Sample 3 0.043 0.038 ...
2
votes
0answers
232 views

Excel VBA not working when “enable editing”

I'm not sure if this is the right place to post this but I'm having issues with excel VBA. I sent a worksheet with custom VBA attached to an email. Once the user downloads the file, it open in excel ...
2
votes
0answers
10k views

How to add custom columns to Pivot Table (similar to Grand Total)?

I have data which I pivot as Row Labels and Column Labels which gives me something like this: And what I would like to do is add columns like Grand Total (i.e. which applies to all columns as a ...
2
votes
0answers
45 views

Excel 2010 clips top edge of content

In Excel 2010 on 2 different computers, the same file opens differently as follows: Correct: Incorrect: The correct one is displayed first. This is a file exported from a SQL Server Report; when ...
2
votes
0answers
796 views

direction right to left Excel 2011 on Mac

I am trying for a long time already and can't find a solution for MAC I would like my excel worksheets to be Right To Left. Using Excel 2011 on Mac. How can I do it?
2
votes
0answers
401 views

Add-Ins not loaded in Excel, when started via opening a file

I'm using Excel 2010 with TFS 2010. When I start Excel directly, "Team" and "Load Test" are loaded. But, if I double click on an Excel file, then Excel started without loading "Team" and "Load ...
2
votes
0answers
374 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
2
votes
0answers
165 views

Store Values from a Dynamic Cell Elsewhere in the Spreadsheet - Building a Database with Excel/Google spreadsheets

I have a list of values that updates as new data becomes available on a website using importXML (cells A1-A25). I want to store those values elsewhere in the spreadsheet so that when the values ...
2
votes
0answers
200 views

Complex Excel formatting of SQL-based data

I'm a db guy making my first foray into formatted Excel documents and am being asked to populate a sheet similar to the image below. I'm looking for general guidance to understanding the ...
2
votes
0answers
262 views

How to get new data to automatically slot into correct column in Excel?

I am trying to move new data into an existing database with set columns. The existing database has a column for every possible type of data, but not all new entries contain all columns. So I can't ...
2
votes
0answers
159 views

Merging CSVs with some common columns (though columns are in different places)?

I'm looking to merge CSVs that have common columns, but the columns aren't always necessarily in the same place. The CSVs do have a header row. I just want to try to get the data appended to the ...
2
votes
0answers
109 views

Insert Excel Spreadsheet Into Word From Access Database

I have an Access database with Excel spreadsheets (files) linked to a field in each record. In Word, I have setup a mail merge which picks up the data from each record and I want to insert the ...
2
votes
0answers
640 views

error while Generating “xlsx” file using carlosag.excelxmlwriter dll

I am using carlosag.excelxmlwriter dll to build Excel files. When trying to build xlsx files, the following error pops up: Excel can not open the file "test.xlsx" because the file format or file ...
2
votes
0answers
188 views

Excel 2003 Freezes When Worksheet with PivotTable Selected

All of the sudden, my Excel 2003 began an odd behavior today. Whenever I click on a worksheet tab that has a PivotTable on it, I become unable to click on any other tabs or on the menu with the ...
2
votes
0answers
252 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
2
votes
0answers
476 views

Excel Pivot Table with external Data Source parameter is not saved with workbook

I have a pivot table in an excel 2007 workbook that links to an external data source. The query is along the lines of "exec procedure @param=?" (using an ODBC connection to sql server 2005). I am ...
2
votes
0answers
882 views

Excel 2010 claims files are corrupted when I open them twice from links

I have several large Excel (2003) workbooks, which are linked. I open A.xls in Excel 2010, then open B.xls from Edit->Links. This works fine, and I can use B.xls. If I then close B.xls, and try to ...
2
votes
0answers
346 views

Activate Excel Add-Ins as part of Deployment?

I am using the office customization tool to create an unattended installation file for Microsoft Office 2010 pro plus. I have everything setup as I like, except that I need the excel add-ins activated ...
1
vote
0answers
30 views

What has caused my csv load time to dramatically increase?

I have a monthly report formatted as a .csv file. It's file size is 90 MB. It used to take around 10 seconds to open. Now it takes 4-5 minutes. When I convert it to an .xlsb, it takes 10 seconds. ...
1
vote
0answers
22 views

Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row. See the picture or xls example https://dropmefiles.com/BDlHe 1st table lookup ...
1
vote
0answers
17 views

Is there a way to use cell references instead of structured table references?

I have a table, on the outside of which is a column of formulas referencing cells within the table. When creating the formula, clicking on the table cells or using the arrow keys to move to the ...
1
vote
0answers
33 views

Excel: how to create multiple rows from one

I have many rows in a document in which I need to insert a certain subset of rows with others. In particular, I need one row for each month considered. If I have the row starting with July and ...
1
vote
0answers
15 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel ...
1
vote
0answers
39 views

Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...
1
vote
0answers
29 views

Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time? See the PivotTable below as well as the source data (both excerpts). If it is in fact not possible to ...
1
vote
0answers
28 views

Opening a file with a # in its path using the default application from Excel 2007

I have a pdf file which is located at "D:\some\#folder\filename.pdf". And want to open it from an Excel worksheet by clicking on a hyperlink (or something similar). Just creating a hyperlink does not ...
1
vote
0answers
78 views

Dependent Drop Down lists and Data Validation; Multiple Lists

Right now, I have My goal: Add a Data Validation List into another sheet such that when I select an item from Column B, everything from Column K appears that is linked through into Column B ...
1
vote
0answers
33 views

Excel (2010) Save and Save As operations cease working

Twice in the past week a colleague has encountered an issue with Excel 2010 where the application suddenly ceases to perform its Save and Save As functions on all open workbooks, with no error ...
1
vote
0answers
17 views

Having problems linking table at a specific webpage in Excel

I am trying to pull live data from http://www.wdol.gov/sca.aspx into an Excel spreadsheet. Specifically the SCA Wage Determined Rates. I want to be able to pull in the table that is generated from ...