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)

3
votes
0answers
65 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
55 views

Strategy to easily update incoming external links to an excel workbook

Lets say you have 2 workbooks Name "PrivateWorkbook" and "PublicWorkbook" PublicWorkbook is accessible to everybody in our company. PrivateWorkbook is only accessible to managers. There are ...
3
votes
0answers
378 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 ...
2
votes
0answers
39 views

Automatic scatter plot in Excel 2010

I have two quite large data sets of which I want to plot every line in one plot. The pattern is the following: x-axis: Set one (Colonne 1-6) y-axis: Set two (Colonne 1-6) Now I want such a plot for ...
2
votes
0answers
28 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
32 views

Wrap paragraphs in paragraph tags in Microsoft Excel

I am using the export as XML feature in Microsoft Excel, I have an XML Schema Definition like so: <?xml version="1.0"?> <xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> ...
2
votes
0answers
162 views

Splitting an excel 2010 spreadsheet into multiple workbook files based on column value

I find and clean a lot of contact data, sorted by country, which I am currently using excel to manage. Mainly because it is easier to clean and manipulate the data I find this way, and I can easily ...
2
votes
0answers
98 views

Calculation takes forever in large data set on Excel

I connected my excel to ODBC SQL Database(SQL Server) and now my excel pivot table is getting its data from the sql server VIEW. There is a total of about 1 million plus rows from the QUERY. From the ...
2
votes
0answers
34 views

Display value in associated row in pivot table

I need to display a value in the same row of data as my minimum value in a pivot table. For example, my pivot table looks like: Row Labels Min of 247 1950 255.42 1951 250.46 1952 ...
2
votes
0answers
90 views

How to sort time column by value instead of alphabetically

I'm creating a pivot table by connecting to an SSAS tabular model (Data -> From Other Sources -> From Analysis Services) . The model has a "time" column that I want to sort by. The default (database) ...
2
votes
0answers
63 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
68 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
431 views

Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
2
votes
0answers
1k 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
119 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
102 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
92 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
160 views

combine Excel rows based on multiple primary IDs

I have several tables of academic journal rankings, from different sources and with different metrics. I want to combine them in a single table, aggregating data by journal. The journals have several ...
2
votes
0answers
403 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
133 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
293 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
829 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
591 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
2k views

What changed between Excel 2007 and 2010 that is causing my copied worksheet save to fail?

When I do this in Excel 2010 this fails, but works in Excel 2007: Create a new workbook and insert an image onto a worksheet, or get a preexisting worksheet with an image. Copy the worksheet into a ...
2
votes
0answers
267 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
19 views

Excel Need to Check one Sheet for Data if True take data and paste in field

I am doing inventory for my company but need to use last years inventory prices in this years quarterly spreadsheet. There are only 3 Information fields. SKU, Qty, and Cost. In the master it has SKUS ...
1
vote
0answers
14 views

Change Excel Zip Compression Level in Windows

Excel compresses its files using Zip-Deflate and stores it. However, the compression level is far from the best. To reduce the size and send it across I have to unzip and re-zip it manually everytime. ...
1
vote
0answers
22 views

Excel 2007: Unhelpful error message if VBA is not installed

My application generates macro-enabled Excel 2007 workbooks (.xlsm files). When a user who did not install VBA as part of their office installation opens such a workbook, they see an error message ...
1
vote
0answers
30 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 ...
1
vote
0answers
34 views

Hyperlinks to web pages in my Excel workbook don't work now

Hyperlinks to web pages, saved in my Excel workbook don't work after upgrade to Windows 7 & new hard drive. Have had this spreadsheet for years. I was always able to click on the link and it ...
1
vote
0answers
34 views

Office 2013 can't open office 2010 protected file,vice versa

I couldn't achieve to produce an interchangeable protected file between Excel 2013 and Excel 2010. Excel 2010 can't open 2013s protected one and 2013 can't open 2010s protected one. I think their ...
1
vote
0answers
19 views

Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be: New view (not Classic view) Autofit column widths on update = on Subtotals = on (top of group) I end up ...
1
vote
0answers
29 views

In Visio 2013, how do I apply various styles to a timeline element based on a linked data value?

I am building a timeline in Visio 2013 using linked data from Excel. It took me forever to figure out that I needed to add the names "Task Name" and "Start" to automatically populate milestones on ...
1
vote
0answers
37 views

One user of computer having trouble opening Excel file from Outlook attachment

There's an office at work here that is shared by 4 different users (1 for each shift). They all have their own unique logins. There is one user that is having problems where when she tries to open ...
1
vote
0answers
49 views

Excel busy CALCULATING for no reason

I have a problem with Excel and some of my spreadsheets whereby whatever action I make (even a basic =2+2): the spreadsheets gets into CALCULATING mode for about 14 sec for some tasks (e.g. =2+2), ...
1
vote
0answers
58 views

Excel 2013 slow when Cell Editing

In Excel 2013 (on windows 7), when I select a cell & type something, most of the time it makes the computer very slow for few seconds, and takes time to display entered text in the cell. Tried ...
1
vote
0answers
25 views

Excel output XML using XSLT

I am attempting to use xml2json-xslt to convert my Excel generated XML to JSON data. It is written in XSL 1.0 so I can run it from the browser and it works just fine. However I would like to include ...
1
vote
0answers
42 views

Word mail merge using excel column to select layout from other documents

I have about 30 word documents. There is 1 document that is the main one setup to use for mail merge. There is a column in the recipiant list that is meant to select the document that will be used ...
1
vote
0answers
34 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 ...
1
vote
0answers
38 views

Excel, sort through columns

I need to sort through a a few excel columns and can't seem to nail down an easier way besides manually going through line by line. Column A has names where names can repeat, column b has state ...
1
vote
0answers
45 views

Using getpivot in excel to create flexible reports based on user inputs

I am trying to make a report in Excel that sits on a very large set of data (set up in proper pivot form). I want to be able to select a value for a few fields (or select a value from 1 field but ...
1
vote
0answers
12 views

MS Excel - How to select a radioButton when click on cell not on the radioButton itself

I'm working on some sort of survey for a client. He sent me an example where you can select a radiobutton by clicking on the cell that contains the radiobutton, I mean, you don´t have to click ...
1
vote
0answers
61 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 ...
1
vote
0answers
21 views

Excel Protected View triggering on Valid Spreadsheet

Our organization has an Excel file that has been around for quite some time. I released a new version of this to users, and roughly 50% of users are getting an error "Protected View Office has ...
1
vote
0answers
51 views

How do I find which Pivot Tables has an error in Excel 2010?

I'm receiving an error: cannot open PivotTable source file ...XLSX SHEET... while refreshing all data. I have many Pivot Tables, and I can't find that one with the error, while refreshing ...
1
vote
0answers
26 views

Excel 2010 won't remember password when importing data

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it ...
1
vote
0answers
112 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 ...
1
vote
0answers
65 views

How do I tell MS Excel to use the non-standard decimal separator in graphs and charts?

MS Excel 2010, using US English as default language. I have a document that needs to use the interpunct (·) as the decimal separator. I can go to File -> Options -> Advanced -> Decimal separator and ...
1
vote
0answers
60 views

Is there a macro to filter table by some list elements?

I have a table with entries based on a list and I used a macro I found somewhere to be able to add/remove multiple elements from the list to one cell, let me show you an example: TEST TABLE test1 ...
1
vote
0answers
24 views

Excel updating automatically

I have two excel worksheets, one for Project Officers and one for Project Managers. So we don't create more work for the project officers I would like to make it so when the POs update their spread ...