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)

5
votes
0answers
108 views

Keyboard shortcuts for selecting range using inputbox in Excel

I am using Excel 2010 and I have a problem with using keyboard shortcuts for choosing ranges in an Inputbox. I am using a standard Application.Inputbox with type:=8. The code prompts the user to ...
3
votes
0answers
46 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 ...
3
votes
0answers
221 views

Excel VBA SQL Query Handles Error

I am a beginner with VBA, but try. 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 ...
3
votes
0answers
165 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& ...
3
votes
0answers
525 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 ...
3
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 ...
3
votes
0answers
578 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.
2
votes
0answers
24 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
36 views

Excel: how to illustrate a budget constraint that depends on more than two factors in a table? Calculate how much of a house you can afford

Imagine that you want to make calculation of how expensive flat/house you can afford to buy. You know how much you can spend on housing per month (100). You also know that there are three factors that ...
2
votes
0answers
55 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
201 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 new ...
2
votes
0answers
39 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
163 views

excel 2010 not inheriting regional settings in windows 8.1

Wondering if anyone else is having this issue. In regional settings on Windows 8.1 i have display negative numbers set to display in accounting mode. eg - (1.0) instead of -1.0 Excel should be ...
2
votes
0answers
346 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
324 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
185 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
5k 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
43 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
505 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
307 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
143 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
128 views

Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003. We are now migrating to Excel 2010, and have encountered the following problem. When the workbook is opened in 2010 ...
2
votes
0answers
169 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
140 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
107 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
563 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
176 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
211 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
429 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
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
829 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
320 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
24 views

Office 2013 on Windows 8.1 gives out of memory error when opening files

We have the same error that has been posted here: Problems opening Excel attachments from Outlook Namely, when a user opens a file from the internet, the internal network or an outlook attachment ...
1
vote
0answers
27 views

Cell Formatting, 0.00 where blank value

I have some cells that are formatted as hours and minutes i.e. [h]:mm. If no value exists in a cell I want the cell to show 0:00 without having to manually type. It needs to be user friendly, so if ...
1
vote
0answers
30 views

Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want): ...
1
vote
0answers
36 views

How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573. However, when Excel calculates these values in a pivot ...
1
vote
0answers
12 views

Refresh data in depth trough multiple closed workbooks

Situation I have 3 Workbooks in the format .xlsx, Source, Manipulation and Result. Result has a link to a cell in Manipulation wich again, has a link to a cell in Source. As the data is manipulated ...
1
vote
0answers
29 views

Remove Rows Not Part of Filter

I am filtering a large Excel spreadsheet. I want to remove all rows on the sheet that are not a part of the filter. I know I can copy the rows and paste them into another spreadsheet. But I would ...
1
vote
0answers
34 views

Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold. For this, I click PivotChart filter and see that filter may ...
1
vote
0answers
61 views

Excel VBA that calls Powershell ActiveDirectory cmdlet, but Module won't load?

I have a powershell script I use to dump user and computer lists to csv files; it works great and I don't want to touch it much. It uses the ActiveDirectory cmdlet, and the Get-ADComputer and ...
1
vote
0answers
23 views

finding data with multiple conditions and replacing it with new data

I am working with 2 worksheets, 1 contains all my raw data and the other works as a dashboard with my pivot table and charts. I hope you can help me create a cell input range in my dashboard ...
1
vote
0answers
32 views

Microsoft Word, Powerpoint, Excel adding unnecessary letters while opening a file

Downloaded and opening a word file from web add the this kind of formatting at the end of each paragraph. What is the reason? Here is the image to let you know the problem ...
1
vote
0answers
18 views

Build comprehensive formula for all precedent cells

Is it possible to build a comprehensive formula for all precedent cells? I'm aware and employ the "Trace Precedents" and "Trace Dependents" feature in Excel often, but this only goes back one "layer" ...
1
vote
0answers
32 views

Show webpage in excel

I have an excel file with a lot of urls, which I have to look through and mark. My idea is now, to preview the urls in a tiny box when I hover over the url. However, I cannot find such functionality ...
1
vote
0answers
23 views

Paste formatting into Excel

I have a script which outputs tab-separated lines that I later paste into Excel (I'm on OS X if that matters) so the end result is a spreadsheet of columns and rows. Is there any way I can add ...
1
vote
0answers
99 views

Office 2013 - Paste Special Shows 'Unformatted Unicode Text' only - Show Options Turned on in Advanced Options

About two weeks ago my "Paste Special" stopped working in Office 2013 products. Before, I could paste and choose how I wanted it to work. But, since, all I have in the Paste Special options is ...
1
vote
0answers
37 views

Excel Formula to Word

I have this formula to give me a specific day of the week. =TODAY()-(WEEKDAY(TODAY())-2) How would I set this up in Microsoft Word 2013
1
vote
0answers
20 views

Conditional Formatting the rest of the column, not the entire column

I want to add conditional formatting to the rest of the cells in the column, not to the cells above. I can figure out how to add it to the entire column, but I want to make sure that the formatting ...
1
vote
0answers
24 views

LC_date like option for excel sheet (possible in libre office)

Windows 8.1, office 2013, english interface - danish region. When working in excel I often paste dates from another application. These dates are in the form Januar 2013. When pasting, it seems excel ...
1
vote
0answers
109 views

Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh

I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post. The problem: Pivot table with 31 calculated fields. Some calculated fields are calculations of the source ...