A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

5
votes
0answers
2k 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
615 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
422 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& authkey=&...
3
votes
0answers
56 views

Highlight differences between two Excel spreadsheets

Data from Spreadsheet A has multiple columns but I need to compare only: Column A - order # Column C - count Column D - date Spreadsheet B also has many columns, but I need to compare: Column A - ...
3
votes
0answers
116 views

How to disable marching ants from overriding my external clipboard data in Excel 2016?

Did the copy-and-paste behavior change in Excel 2016? Every time I want to copy something from an external application, I have to press Esc first in Excel 2016 to cancel the marching ants (selection ...
3
votes
0answers
72 views

Checkbox location changes when workbook is opened in Excel 2010

I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell. When I open it at work with Excel 2010, all the ...
3
votes
0answers
413 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 ...
2
votes
0answers
16 views

Show MS Excel Syntax as you type Formula

I have Office 2013 on my work computer and Office 2016 on my personal computer. On my work computer in Excel 2013 when you type a formula you get the suggested syntax for formulas as you type, but on ...
2
votes
0answers
19 views

Copy sheets to new workbook and clearing contents of cells in the new workbook

I am trying to copy various sheets into a new workbook, however, I would like to clear some of the contents after this is done in the new workbook. To better illustrate it, I have sheets a, b, c, d, ...
2
votes
0answers
83 views

Excel- How do I find common text values from multiple (>2) rows?

This is essentially a variant of the question asked here: Excel- How do I find common text values from multiple (>2) columns? In this case, however, instead of multiple columns of data I need to ...
2
votes
0answers
122 views

Upgraded to Windows 10 - Macros Broken

Problem: I finally upgraded to windows 10 and a few macros in excel 2010 that I use frequently no longer work. They crash instantly when I run them and all I receive is an "automation error". They do ...
2
votes
0answers
104 views

VBA prompt for Copy and paste from combo box in active cell

Could anyone help me to copy and paste from combo box in active cell and below mentioned code created to copy and paste from drop down in active cell but i need a code to copy paste in any cell where ...
2
votes
0answers
49 views

Legend-placement in two different charts is different with same settings

I have two charts, and in both of them I want I want to place the legend in the upper right corner of the chart-area like so: However when attempting to add a legend to the second chart, it is ...
2
votes
0answers
204 views

Excel file opens but when ready to save the file is readonly

Here is the situation. Windows Server Essentials 2012 R2 and windows 7 pro via domain. Laptop user opens 6 excel files. next he goes home with the files open to work on them. when he comes back to ...
2
votes
0answers
28 views

Copy hyperlinks from original list to search index list

I've created a search index (using formulas) from a list of products that have hyperlinks attached (created with Insert Hyperlink). The search index is created without the hyperlinks however. Both ...
2
votes
0answers
86 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
480 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
721 views

Is that possible to have a Shamsi (persian) Calendar in Windows? What about Microsoft Office

Is there any solution for replacing the current Georgian Calendar of Microsoft Windows with Shamsi (Persian) Calendar? Although, Microsoft Excel and other packages of Microsoft Office must recognize ...
2
votes
0answers
2k 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
377 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
66 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
771 views

Get rid of warning for external data connection

In Excel 2011 for Mac, I'm using an external data link to collect data from a CSV file generated by a third party application. The CSV is continuously filled, so I want to update the data every time I ...
2
votes
0answers
238 views

How to stop IE opening Excel spreadsheets in embedded mode?

When we open an Excel workbook with Internet Explorer (D:\Book1.xlsx in address bar) - IE opens the Excel workbook in embedded mode. It triggers Excel with the following option C:\Program Files (x86)\...
2
votes
0answers
252 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
277 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 Excel-...
2
votes
0answers
433 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
188 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
117 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
765 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
205 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
439 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
592 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
188 views

ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it

I haven't been able to find an answer to this. I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is ...
2
votes
0answers
1k 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
1k views

The best way to sync an MS Excel file with DB data (including saving it)

I have an Excel file that is supposed to mirror some data from an MS SQL DB. This file is synced automatically to a remote location. I would like that whenever the Excel file is synced, the data that ...
1
vote
0answers
10 views

Disable auto date formatting in Excel

My cells are set to text format but when I find and replace numbers in them they automatically change themselves to date format even though I don't want that. How do I globally disable automatic ...
1
vote
0answers
20 views

Block Network access for Microsoft Excel

I have a macro that is stuck on running and has frozen my Excel. Basically its a loop through roughly 80000 rows performing SQL queries on each row with ADO.DB Save disabling the network card, is ...
1
vote
0answers
27 views

Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like . The table shows four projects, each with three stages with each having an expected and actual start date for that stage. I want to create a ...
1
vote
0answers
19 views

Is there any way to put a thermometer chart inside of the category name on another chart?

I'm using Excel 2016 and have a bar chart showing Manhours/Actual Hour. I want to make the horizontal category labels have a separate bar chart within them, showing time spent out of time possible (...
1
vote
0answers
15 views

Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...
1
vote
0answers
17 views

How to format historical dates in Excel?

I'm compiling list of historical events spanning from ancient history till current day in Excel 2016. Because I love the filtering and sorting capability of tables in Excel. The problem is that we don'...
1
vote
0answers
37 views

Excel Text Import Wizard Default Delimiter

Within the Text import Wizard, the default delimiter is TAB. Is it possible to permanently modify this default to be a comma? Don't be tempted to think that this is a duplicate question. Neither this ...
1
vote
0answers
36 views

macro's gone before/after saving to .docm

I am working on an excel file that opens a source document(word) that I want to save to another name but with the macro's from the source. Opening the file is not the problem but after this merge (I ...
1
vote
0answers
34 views

How to Mirror Cells when the source is a data validation list? (Excel 2010)

I have a workbook with two tabs. The first tab is being used as a table for data validation lists I'm creating in the second page. For example, one list is called "Supervisors". This list starts cell ...
1
vote
0answers
23 views

excel 2013 clipboard entries

Sorry for missing a step between 2 & 3 on my original post. Edited portion is inserted in bold text (step 3). I got this excel 2013 copy-paste command problem that occurred a couple of days ago. ...
1
vote
0answers
19 views

Forbid hiding Excel sheet

Is it possible to disallow a sheet in Excel from being hidden? I have a workbook with multiple sheets, many of which can and are hidden if not required. Some of the sheets should always be required, ...
1
vote
0answers
25 views

Display hyperlinked text

I'm trying to display the value of a hyperlinked text into another cell. For example, I have a column that contains several hyperlinks each linked to a specific cell in other sheets. What I would like ...
1
vote
0answers
16 views

how to get csvkit to convert very wide xlsx files — weird error messages

I've been trying to convert a number of xlsx files which are very wide (over 200 columns) into csv files so I can aggregate them into a single file for analysis. I've been trying to use csvkit, but it ...
1
vote
0answers
21 views

Table relationships across 3 tables and updating all with a single slicer

I have 3 tables with data. All of which have a username column and I'm trying to connect them. For this purpose I have created a 4th table which is basically just the User directory (where each ...
1
vote
0answers
41 views

Excel 2016, “{}” disappearing in formula

I've modified an existing template called "Daily Schedule". For some reason, all of the cell formulas have "{}" around them. When I click into the cell to edit the formula, the "{}" disappears. After ...