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)

4
votes
0answers
50 views

Kanji changing to boxes in Excel when I switch from Japanese to English input.

I'm creating a database that includes a column of Japanese amidst many columns of English, but every time I switch my input language to English, the kanji turn to boxes with the character 字 inside ...
3
votes
0answers
38 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
785 views

IE9 not prompting to save downloaded CSV file, opens in Excel

I am accessing a website that generates CSV files when I click a "download" link. Instead of prompting to "save or open", IE 9 is going right ahead and trying to open the returned file in Excel. Since ...
3
votes
0answers
248 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
850 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
536 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
32 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
103 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
65 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& ...
2
votes
0answers
125 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
62 views

Is there a way to automatically display the file path on every print whether its Word, Excel, PDF

I am working with one of our help desk tickets and I personally don't think it's possible unless you go through some crazy scripting... The help desk ticket client was asking if is there a way to ...
2
votes
0answers
249 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
214 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
175 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
51 views

How to attach a note to a specific date in a dynamic graph?

I have a graph that I update every month with new data. I want to annotate some comments to relevant days inside the graph, and when I update it, they stay fixed to that days. Now, I draw this notes ...
2
votes
0answers
37 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
119 views

Excel link in Word docx

I use a Word file to put it as a report in which I integrate tables and charts from an Excel file. More precisely, on a network drive I have many Excel and Word files. Each Word file has its Excel ...
2
votes
0answers
83 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 ...
2
votes
0answers
120 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
107 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
2k views

64-bit Excel 2010 Solver - Solver32.dll not found

I am trying to use Solver in 64-bit Excel 2010. When I run Solver, it opens the solver window, states that it has results and then popups the following error message: Run-time error '53' ...
2
votes
0answers
150 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
121 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
101 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
502 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
168 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
187 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
387 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
761 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
301 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
14 views

How do I separate a word document according to a list and email

I am using Office 2010. Our payslip comes in a word document and I usually print out and deliver to each staff. Each page has each employee's payslip. However, I want a macro or VB script that can ...
1
vote
0answers
16 views

Gantt Chart Template using dates

I am using the Gantt Chart Template and I have changed all the period numbers to dates and the plan start to dates as well. It works great until I change the periods to weekdays. It continues to ...
1
vote
0answers
26 views

Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...
1
vote
0answers
33 views

Text to copy cells with formatting into Excel

I am looking for a way to copy-paste text into Excel, which Excel will recognize as formatted (ie, styled or colored, etc) cells. On the one hand, Excel recognizes tab-delimited text pasted from the ...
1
vote
0answers
37 views

Unable to insert rows or columns in Excel 2013

I'm using Office 2013 on Windows 7. Few times, I have not been able to insert rows / columns in a some of the Excel spreadsheets. I tried the following before searching on the internet. Use ...
1
vote
0answers
33 views

file:// protocol in Excel and Word - Hyperlink URL changes

Clicking on file:///D:/UpToDate/contents/mobipreview.htm?3/4/3141 in Microsoft Excel opens an URL in a browser but omits the file:/// and ?3/4/3141 portions from the hyperlink thus the resource ...
1
vote
0answers
32 views

Link Microsoft Excel to Word document

I need to link certain numbers in my word document to an excel file that I have. For example, the Revenue for FY2014 is "20,000". I would like the 20,000 to be linked to a certain cell in an excel ...
1
vote
0answers
28 views

How to save Ping record in every single hour for 2 weeks?

how do I save the record ping "in every single hour" for a certain period, for example for 2 weeks, with the format dd / mm / ss, dd / MM / YYYY and beside it is the result of the ping. So we can ...
1
vote
0answers
13 views

Multi Series Graph on Excel for Mac

I'm trying to fit twelve different series on a scatter plot with x and y variables. Excel doesn't seem to recognize this. How do I design this graph? All I keep getting is this:
1
vote
0answers
9 views

Windows Xperia excel 2010

I have 50 work books each work book is for 1 subcontract operative. Also each operatives work book has 52 sheets one for each week. I need to extract the same cell (£ payment total) to list the weekly ...
1
vote
0answers
14 views

How can I open a PDF to a certain page from within excel?

I would like a macro code for Excel 2013 that will open up a certain page upon clicking a button in the excel cell. I am using the below code, but it is working intermittently. Please help with a ...
1
vote
0answers
17 views

Bloomberg - Excel VBA Macro to email Bloomberg <CN> screen via <GRAB>

I am looking to develop an Excel-Bloomberg macro. The excel spreadsheet will be linked to a Bloomberg Add-In and of course, a Bloomberg Terminal. The objective of the macro is to have a list of ...
1
vote
0answers
25 views

Why does Excel 2013 Ignore My Keystrokes?

So I was doing some copying and pasting into this new Excel file, and all of a sudden the keyboard is not being recognized in Excel. I also am unable to save this file. Anyone have ideas? Here is a ...
1
vote
0answers
35 views

Return a value adjacent to the first negative number in a column

I have a retirement calculator and I'd like to add a cell showing how long into retirement my savings will last. So I want to have it display the date (column A) that my balance (column C) first drops ...
1
vote
0answers
25 views

How do I change the function field in excel to show Bengali Characters?

I received an excel file that has columns translated from english to Bengali. I have a Bengali font installed and it shows up in the main body of the spreadsheet but the characters are not showing up ...
1
vote
0answers
108 views

Reset Numbered List with Text Style VBA macro MS Word

I'm trying to make a VBA macro to create a Word document from Excel... Currently I'm having issues with setting up the Lists properly. I want the list indexes linked to my 2 header types. Like so: ...
1
vote
0answers
28 views

Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done. The problem is when directory was built I noticed that there were some errors. I want to ...
1
vote
0answers
29 views

Embed an Excel spreadsheet into the body of an email

I want to embed an Excel spreadsheet or some other kind of calendar into the body of an email. I am making the calendar and using hyperlinks. Is it possible to put this in the email with the ...
1
vote
0answers
20 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)?