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)

1
vote
0answers
31 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
38 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
1k 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
96 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
237 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
187 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
177 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
1k views

Scroll Lock key on for keyboard lights but off for Excel

My keyboard uses the Scroll Lock key to turn the lights for the keys and key background on and off. Excel uses the same key to control movement when using the arrow keys. How can I "tell" Excel the ...
1
vote
0answers
147 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
67 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
123 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
791 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
453 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
108 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
600 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 ...
1
vote
0answers
433 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
463 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
137 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
41 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 ...
1
vote
0answers
144 views

automatically transfer any data on excel spreadsheet to master spreadsheet

I work in a library and I am working on a workbook to track our orders from one company. I have three sheets where each sheet represents a different branch of our library. I am trying to have it set ...
1
vote
0answers
140 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
106 views

How to copy exact cells into another Excel file?

I need to copy some cells from a row into another Excel sheet. The cells in target sheet are not in same row. The starting row is changing and that is why my idea is following: run a macro, choose ...
1
vote
0answers
165 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
242 views

Incrementing ticket numbers each time I print

I have an excel sheet to print a set of 4 tickets per page which we use for stock takes. I found code that prints one number per page. Being a Visual Basic for Applications novice, I was unable to ...
1
vote
0answers
160 views

Select split rows in Excel and have them print on the same page

I'd like to select several rows in Excel from one sheet, that may not be next to each other and when they are printed using the "Print Selection Only" option, show up on the same page, instead of one ...
1
vote
0answers
48 views

How can I move columns based on the column header title to another workbook?

I have to average grades based on each objective for a new report card we have to complete this year. Column one has students names, each additional column will have the objective associated with the ...
1
vote
0answers
197 views

How to export Excel with Hindi script to CSV file?

I would like to know how to export an excel spreadsheet which contains, say a table of Hindi(for that matter any non-english) script words into a CSV file? I tried 'Save As' --> comma delimited, but ...
1
vote
0answers
360 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
83 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
2k views

Remove 'file locked for editing' attribute from MS Word/ Excel documents

In the same essence as this question Excel file locked for editing. Is there a command I can type to remove the lock flag? for example: attrib -R example.docx -- The story -- In our office we ...
1
vote
0answers
42 views

Excel for Mac 2011 move column 2 in sheet 1 to column 1 in sheet 2

I would like to move column 2 into column 1 for each successive sheet, one sheet per week, automatically. Is that possible? I do it with this formula ='1st week'!D2 and manually changing '1st week' to ...
1
vote
0answers
30 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
33 views

Powerpivot will not install

I am trying to install 64 bit Powerpivot on a 64 bit Excel 2010 platform on a Windows 7 64 bit machine. I get an error message saying Excel 2010 must be present first, even though it already is. ...
1
vote
0answers
294 views

How to avoid security certificate errors/warnings raised by excel when retrieving data using querytables

How can I avoid security certificate errors/warnings raised by excel when retrieving data using querytables from a server that has multiple certificates (we do not wish to revert to the use of ActiveX ...
1
vote
0answers
206 views

MS Office applications (ALL!) always on top

I've searched a while and seen specific Add-on or taskbar lock/unlock fixes for Excel, Word, and Outlook, but I've having the same issue with the windows always staying on top for ALL programs. This ...
1
vote
0answers
101 views

Splitting Excel file but retaining lookup data and formulas

I have a master expenses file that has a page for each employee summarising their expenses. The employee sheets run off a hidden data sheets. I want to send each employee a copy of their expenses ...
1
vote
0answers
128 views

Excel97 crash, Windows 7, VBA, DEP

I've not be able to get Excel 97 VBA to run correctly on Win 7 without turning DEP entirely off. Access97 runs ok with just an Access DEP exception, But making Excel a DEP exception has not helped. ...
1
vote
0answers
410 views

How can I copy spreadsheet cells into word document?

I'm trying to copy a selection of cells within a spreadsheet across the word and have changes appear in both sp doc and Wd doc. I have read this answer you gave from another with the same quest: ...
1
vote
0answers
109 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
557 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
153 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
485 views

Excel - One Slicer To Rule Them All

In excel I have multiple sheets with different pivot tables and charts. Each of the sheets has different slicers, but they all share one in common. I would like to make a global slicer on my main ...
1
vote
0answers
654 views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
1
vote
0answers
239 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
61 views

Custom views to view rows in excel

I have an Excel Spreadsheet (Excel 2010 version) with lots of data. There are around 20 columns and thousands of rows. Now the column widths are big so the columns don't fit on the screen and I have ...
1
vote
0answers
378 views

Cannot insert a command button

I followed this step-by-step tutorial to insert a button into an Excel sheet: http://www.excelbeispiele.de/Schaltflaeche.htm (It's German, but the pictures speak for themselves.) However, steps 2. to ...
1
vote
0answers
216 views

How do I create a master list in excel that displays the most recent entry from each tab on a worksheet?

I'm creating a workspace (on excel 2003) with three worksheets: active, inactive, and master-list. Tabs will move between active and inactive, based on whether or not I'm currently focused on them. I ...
1
vote
0answers
55 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
59 views

Is there any way to prevent opening of excel file when opened by other user?

I've created an excel spreadsheet on a network drive. The problem is that users open it concurrently, then save their edited version to the desktop. This means we either lose the edits of the person ...
1
vote
0answers
135 views

Importing data from database into Excel Web Services with parametres

I need to enable people to import the data they need from an SQL Server database into Excel Web Services in SharePoint. They should be able to choose certain parametres for the query. So, for example, ...