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)

4
votes
0answers
579 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
368 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
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 ...
3
votes
0answers
36 views

Editing a “Fixed Width” Text File

I had originally drafted this question in Engineering SE, but on second thought it makes a lot more sense here. I don't know if SuperUser SE just doesn't have MathJax formatting or if I don't know how ...
3
votes
0answers
154 views

Excel 2016 Freezing when entering data into a spreadsheet with multiple formulas

When working in spreadsheets with multiple formulas, if users enter data into a cell then leave the cell, Excel freezes for a few seconds to a couple minutes. The time varies depending on which ...
3
votes
0answers
83 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
48 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 ...
2
votes
0answers
27 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
45 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
176 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
23 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
79 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
426 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
661 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
333 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
60 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
708 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
223 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 ...
2
votes
0answers
233 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
265 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
383 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
183 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
114 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
731 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
203 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
400 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
575 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
187 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
984 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
400 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
26 views

Excel doesn't create structured formula for all tables

Structured formula case I am facing 2 weird issues with Excel 2013. I have been mainly using the tables. Initially when I created the sheet and inserted tables and added formulas, they were all using ...
1
vote
0answers
9 views

Plot a chart directly from a function in Microsoft Excel

I need an help with chart plotting in Excel (I'm using Excel 2016) let's say we have a simple function like: y=1/x Right now, to plot a chart based on this function I use two columns. In the left ...
1
vote
0answers
17 views

Spreadsheet Compare with locked/hidden cells

I created a worksheet in Excel 2013 with several tabs. There are a number of values and formulas we do not want users seeing or playing with. Most of the cells are locked and hidden. Several of the ...
1
vote
0answers
11 views

Row and Column grouping buttons have disappeared on certain sheets

I have lost the grouping buttons and leader lines for column and row groupings on certain sheets in a workbook. Have tried the following without any success: Display options (Options>Advanced) - ...
1
vote
0answers
34 views

Phantom Dropdowns appearing in excel spreadsheet

I'm having have an extremely odd issue with Excel 2016. I have two worksheets, and one of them works fine. However my second sheet has a peculiar issue involving a certain row of excel dropdowns. If ...
1
vote
0answers
27 views

Asking password 2 times while opening Excel files over Internet

The problem is with a Lenovo Iomega IX2 NAS. When I open Excel files via Internet (IE, Chrome, FF, Win 7, Win 8 ...) on that NAS, it ask me two times to enter a username and a password. I have to ...
1
vote
0answers
20 views

Logarithmic scale in Excel chart with non-transformed axis labels

I'd like to change a plot so that the y-axis has a logarithmic scale. But when you check the box "logarithmic scale" it also transforms the axis labels. I would like to have the axis show only ...
1
vote
0answers
44 views

How to recover damaged Excel files

I have a few Excel files which are not working since a sudden attack by some unknown virus. It then encrypted all my values in the datasheets. I have no backup for those Excel files. I need to recover ...
1
vote
0answers
15 views

How to overwrite measures at a line level in PowerPivot

I have two tables, each of the same dimension and same level of granularity; Date, Site, Campaign, Ad Group, Keyword are the columns, with spend as the single measure. What I am wanting to do is ...
1
vote
0answers
22 views

Automatically categorizing after associating text in two columns.

How do I associate a category (could be from a drop down list) to text/name in another column automatically after associating the first one. Example with categorizing transactions in a list. Column A ...
1
vote
0answers
30 views

Pass parameter to external application using Excel - WITHOUT VBA or macros

I am trying to pass a method and parameters to a program (written by me) using Excel. for example: goto (45302) However, for various reasons, I want to be able to do it without the help of a macro. ...
1
vote
0answers
24 views

How did I reverse my Excel Datasheet Display?

How did I reverse the layout of my workbook? I was about to paste some data by pressing CTRL+Insert and now Cell A1 is in the top right of my worksheet instead of the top left. Everything in the ...
1
vote
0answers
30 views

Find X-value to corresponding Y-value from function

Output For those of you who know vertical addition and kinked demand curves in economics, this is it. I have the two following functions: f(x) = -0.5x+120 f(g) = -0.5x+35 f(x+g) = -x+155 I want ...
1
vote
0answers
25 views

Function names in international versions of Excel

I'm writing a documentation how to use some Excel functions in a rather company specific context for novice users. I noticed that the functions seem to have completely different names in non-English ...
1
vote
0answers
32 views

Excel Chart, Axis Formatting

I have a problem with my Y Axis. Here is a sample (click on it for a larger view): As you can see the axis #'s are off. The chart numbers are actual finish times for stages in a race, these times ...
1
vote
0answers
51 views

Excel grey and black boxes on secondary display

My secondary screen doesn't display Excel properly: it has grey, black and white boxes and lines everywhere. As I scroll up and down, or zoom in and out, the boxes disapear and and then reappear in ...
1
vote
0answers
34 views

Office 2013: Pasting graph from Excel changes decimal separator. Changing the format code turns my axis values into zeroes

I have created charts in Excel 2013 where I have managed to change the decimal separators to points instead of commas (I'm on a Swedish computer). When pasting these charts to Powerpoint (or Word for ...
1
vote
0answers
40 views

Pivot table with dynamic field names in Excel 2010

I am creating a workbook where the user can paste in their dataset in a worksheet. This dynamic range will be used to generate a series of pivot tables on subsequent worksheets. This works well when ...
1
vote
0answers
23 views

Expanding specific sections of a pivot table in Excel

I have a pivot table segmented by years, quarters and months. If I try to expand a quarter for 2015, however, the corresponding quarter in all other years are shown as well. How can I expand only one ...