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
48 views

What does the TABLE function do?

I got a the formula {=TABLE(C7,C5)}. I cannot find any table name from ribbon Name Manager, so I think there is no table. So, what is this formula doing ?
1
vote
0answers
80 views

Can Excel be configured to not display the “Compatibility Checker” save dialog?

(I already posted this question on Stack Overflow. It was recommended I post it here as well. I probably should have "migrated" the question, but I'm not sure how that is done.) The situation: ...
1
vote
0answers
31 views

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.?

When I import a table from R to Excel the numbers change from this 1.6329932 to this 16.329.932.??? I need to convert 16.329.932 back to 1.6329932. the table has a lot of values and all have changed ...
1
vote
0answers
51 views

Is the Excel “Last Modified” time adjusted to my timezone?

I'm looking at a Last Modified time stamp in an Excel Workbook: I got the spreadsheet from China, and I'm sitting in Denmark. These two countries are in two different time zones, and I would thus ...
1
vote
0answers
68 views

Format Excel to Display Second Time Zone in Graph

I need to make my Y axis in a graph show the time in HH:MM (local) format as well as HH:MM +/- offset for another timezone. Form example: 09:00 EST 06:00 PST Is there some sort of custom format ...
1
vote
0answers
54 views

Excel: Replace Number Format in Diagram

I have an Excel Workbook which will be sent to a client and I need to get the thousands and decimal seperators right. I have a Workbook.Open routine which will change to custom formatting (and back on ...
1
vote
0answers
63 views

How to search Excel conditional formatting formula with specific text

Sorry I did try to search but could not find a question similar to what I want. My Question: Is there any easy way I could search all conditional formatting that has formula with specific text? I ...
1
vote
0answers
349 views

Transferring Data Between Workbooks Based on a Value in a Specific Cell

I have created a form in Excel that moves information entered in the form to the adjacent sheet in the same workbook as well as my agents workbook at a different file path. That piece of the puzzle is ...
1
vote
0answers
135 views

Combining train trips in a spreadsheet

My student job entails planning the shifts of a number of surveyors who ride on selected trains and count passengers. I would like to know if there is a way to make this task easier, probably in ...
1
vote
0answers
100 views

Word 2007 Merge Document - creating only one letter to recipient for multiple records

Record 1: Mary Smith, Barney Record 2: Mary Smith, Pebbles Record 3: Mary Smith , BamBam Record 4: Bill Shoe, Rocky For example, Mary Smith is listed in my database 3 times with 3 different ...
1
vote
0answers
196 views

updating links in LibreOffice Calc xlsxfile results in err:509

I have just started to use Libreoffice so I am totally new to the system and immediately encountered a problem with a calc document. The document has originally been made in Excel (but on a Mac) and ...
1
vote
0answers
40 views

Trouble adding values from different ranges in excel

I have a fairly unique problem I am having trouble with. Essentially, I need to fix column U on Sheet 1. Ignore stuff out of the tables, as most of that is stuff I either will hide but reference, or ...
1
vote
0answers
57 views

MS Excel sort column containing non-latin characters

Is it possible to sort a column containing text strings in Excel when the script is non-latin, e.g. cyrillic? If so, how? ...
1
vote
0answers
869 views

How do I create a master workbook in excel?

In powerpoint we have something called a master slide. I want the same idea for excel. I want to create a template that I can work on with formulas and I want it to update all children files. ...
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
40 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
2k 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
105 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
259 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
206 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
216 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
163 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
70 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
141 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
908 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
516 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
125 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
255 views

Moving cells in Excel 2013 is slow compared to Excel 2007

I am using Excel 2013 with a simple workbook. It contains ~30 sheets, and ~80 rows and ~20 columns per sheet, filled with numbers, and the sum of the rows of one sheet is used as the first cell of the ...
1
vote
0answers
515 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
507 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
147 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
152 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
145 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
114 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
177 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
274 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
177 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
53 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
225 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
86 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
32 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
34 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
321 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
213 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
104 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
133 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. ...