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
592 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
387 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
89 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
61 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
408 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
48 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
47 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
187 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
26 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
83 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
444 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
683 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
352 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
62 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
727 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
227 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
240 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
270 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
400 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
185 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
735 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
419 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
580 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
993 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 ...
1
vote
0answers
31 views

Put parentheses around sold items in Excel Formula

I would like to add parentheses to several columns in excel that will show items sold and will be subtracted from the finals column. Not sure what the formula would be.
1
vote
0answers
15 views

Excel Pivot chart with a legend summary table having SUM and COUNT of values

I have a pivot chart display some data I'm interested in. Using a summary table below the chart I can plot the SUM of the values. This works great for me since the data rows contains a 1 if I want to ...
1
vote
0answers
42 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 ...
1
vote
0answers
12 views

Excel “Removed Records: Formula from” log file does not identify what was removed

I modified the range of a formula within the spreadsheet's sheet6.xml file using the regular expression change/replace feature of EditPlus, using this regular expression: Find: (SUM\(J.*:)(S)(.*\)) ...
1
vote
0answers
10 views

Replicate cell format as well as value in referenced cell

I want to reference another cell, and display not only the value of the referenced cell, but also it's format. For example: If cell A8 contains `=B8` and B8 displays as `$1,234.56` I want cell ...
1
vote
0answers
38 views

What is this extra drop down in Excel, and how do I get rid of it?

In Excel, I have two adjacent cells with the same Data Validation applied. When selected, the bottom one has the appropriate drop down widget to the right. Clicking on the widget works normally, ...
1
vote
0answers
24 views

How do I define an equation in Windows 10 Excel

I am trying to update a spreadsheet that was created years ago by a person who no longer works for this office. Some of the functionality is not working and I am trying to decipher what is broken ...
1
vote
0answers
29 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
11 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
21 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
15 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
30 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
23 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
49 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
42 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
37 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
27 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
36 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 ...