The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

5
votes
0answers
91 views

Excel spreadsheet undoes/reverts to previously saved state

A very unusual problem hunts my colleague From time to time when she works with Excel 2010 (numerous workbooks, some of them quite large), the computer "decides" to undo everything that was done since ...
3
votes
0answers
43 views

show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown. Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...
3
votes
0answers
461 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
207 views

Why would an Excel 2010 spreadsheet with VBA lag when opened with other large excel spreadsheets already opened

I've got a relatively small (~100K) Excel 2010 spreadsheet that (via VBA) when opened, closes all worksheets except the start page, checks the user name and cross checks it with a SQL table, bringing ...
2
votes
0answers
50 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 ...
2
votes
0answers
53 views

Inserting Excel file as an image in email using Outlook 2010

Yesterday at work, I was sent an email from a co-worker containing an embedded Excel 2010 object. I have Outlook 2010, as does the sender. Instead of being able to work in the Excel object or make ...
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
214 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
68 views

Excel 2010 - Voice command to select cell?

I am using Windows 8, but I would like to know if the solutions provided are also applicable in Windows 7. I use Excel 2010. What I want is a way to select a cell in an open excel worksheet, using ...
2
votes
0answers
64 views

Excel 2010 / Outlook 2010 - Changing the size(with precise numbers) of a chart exported from Excel to Outlook?

If I export(copy&paste) charts from Excel 2010 to Outlook 2010, I'm not presented with a "size proprieties" option when trying to resize them. Since I have multiple chart to resize for each ...
2
votes
0answers
69 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
76 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
563 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
290 views

Excel: Why is VLOOKUP returning inconsistent and unexpected results?

I'm automating an Excel column to assign account values based on the vendor paid. For instance, if AT&T gets paid, the account value is Utilities:Telephone, and when the post office is paid, the ...
2
votes
0answers
446 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
661 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
242 views

Multilingual spreadsheet

I need to make a spreadsheet template that needs to be support both English and Spanish. I know Office 2010 has an option to translate content into desired language but its a manual process. Is there ...
1
vote
0answers
28 views

Excel: Keeping references/links when transposing

I have a worksheet in where I have table (let's call it the summary table) with references to a another table (among others) which is 2x40 (rows x columns). I would like to tranpose this into a 40x2 ...
1
vote
0answers
30 views

Weird Excel 2010 VBA Window Behaviour

If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting. The next time I am sat locally to ...
1
vote
0answers
23 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
162 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
72 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
37 views

Word converting linked excel objects to text table when updating

I have several Excel tables that I have embedded as linked objects in a Word file. They look great for the monthly report. However, when I go to update the Word doc the following month with updated ...
1
vote
0answers
113 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
107 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
67 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
130 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
65 views

Automatically print specific worksheets from within Excel workbook?

I have an Excel workbook with multiple pairs of worksheets, where the first worksheet of each pair contains raw data and the second worksheet is a 'tidied-up' version of the raw data for printing off ...
1
vote
0answers
46 views

atomatic (auto-re-calculate) fill series between 2 variables

I need to fill in column c series of dates or numbers in range of values in A1 and B1. Example: A1 B1 C 17/12/2013 04/12/2013 17/12/2013 ...
1
vote
0answers
209 views

Pivot Tables - Filter Behavior, Limiting Filter Drop Downs Based on Previous Filters

I am working in excel 2010, and I have a question about pivot table filter capabilities / limitations. I tend to use complex, extensive pivot tables for data analysis/data accuracy on huge datasets, ...
1
vote
0answers
76 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
84 views

Excel says file is unreadable in Read-only, but the file is fine in normal mode

I've done extensive research and tried re-installing Office 2010 a few times, but I cannot seem to be able to open files in Read-Only mode in Excel. Whatever the extension (xls, xlsx, xlsm, xlsb...), ...
1
vote
0answers
78 views

How can I edit this macro to loop through the results?

I am trying to select one cell to the left and to the right of a cell I have found by it's value. I am new at writing VBA macros and have hacked together the following script from a few different ...
1
vote
0answers
100 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 ...
1
vote
0answers
148 views

excel sql server error: Invalid object name

I access a stored procedure on a Microsoft SQL Server 2005 database within excel using Select * from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode') in the data ...
1
vote
0answers
110 views

Adding an Windows 7 Explorer indexable custom property to an excel file

I have a folder full of Excel files which are customer invoices. Each morning I check my bank, find amounts that have been paid into my account and then do a search in the invoice folder to find an ...
1
vote
0answers
77 views

Arabic script is not displayed correctly in Excel

I have a list of arabic words in .csv format. When I open the file in Excel, the arabic script gets garbled, see the screenshot. The .csv file is saved in UTF-8. How do I configure excel to show ...
1
vote
0answers
56 views

.xls Excel File With Protected Fields Allow Editing in 2007, Not 2010 or 2013

We have a form in use at the office. This form is a .xls file. Most cells are protected with the exception of data entry cells. I am able to edit at will in Excel 2007, however in 2010 and 2013, any ...
1
vote
0answers
24 views

How do I organize Information in different cells into specific columns?

I have a large document and the information is randomly arranged and I need to organize it in columns. The header of the document is like; name | address | email_address | date The email address are ...
1
vote
0answers
125 views

Grouping in Excel

I have 3000 rows with 25 columns of data. I would like to group data based on the value in one column. This column has numbers (basically a bill of material). So the data is like 1 2 3 4 4 4 5 4 3 4 ...
1
vote
0answers
70 views

excel: how to filter for a specific ID given time constraints on a text field

I have an excel sheet that has a three fields: USER_ID | DATE_CREATED | TAGS Tags applied to the items in the sheet vary quite a bit, and are set up like |tag1 tag2 tag3...| within the field. I ...
1
vote
0answers
357 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 ...
1
vote
0answers
140 views

How might I evenly assign arbitrary categories smoothly across a large population?

Does Excel have a feature or set of features that can be used to accomplish the opposite of sorting? So, rather than sorting rows so that similar values are contiguous, I want similar values optimally ...
1
vote
0answers
2k views

create Macro in VBA with colors if the value of the cell is greater than 100, the macro will change background color of the cell to blue

How can I create a macro in VBA that accomplishes the following: For the active cell, if the value of the cell is greater than a number, the macro will change background color of the cell .
1
vote
0answers
113 views

Format Cells Dialog Does Not Open

I have a worksheet in which Format Cells does not open on any cell in the sheet: • It does open on other sheets in the same workbook. • The worksheet is not protected. • I saved it in current ...
1
vote
0answers
44 views

Excel opens previous revision of file for a specific user

I have a user that opens an Excel file on the network and gets an older revision of the file. Everone else can open the file fine. this user received a new computer and new version of Excel (2010) ...
1
vote
0answers
199 views

Paste html into Excel 2010 without Excel parsing the html

I'm running a query on SQL. Typically I can easily copy and paste the results from the query into Excel and it preserves the columns, rows etc. However, in this case I'm selecting a bunch of emails ...
1
vote
0answers
49 views

linking numbers outside a pivot table to pivot table totals

I have a summary table of budget to actual sales and I inserted a pivot table at the bottom that will automatically update to show the details of the summary. I want my summary table actuals to be ...
1
vote
0answers
214 views

Copying Excel Spreadsheet with Absolute Hyperlinks to Documents (change to relative?)

I have a large spreadsheet created in Excel 2010 with nearly 100 pdf and word documents hyperlinked in hundreds of cells. I had planned to copy the folder the spreadsheet is in - which contains the ...
1
vote
0answers
29 views

How to convert text to a reference

Excel 2010 does not update hyperlink references when previous rows to the destination are added or deleted unlike excel XP. I can create a reference as text by searching for the proper cell on ...