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
245 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
67 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
1k 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
26 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
29 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
204 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
164 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
86 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
120 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
292 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
89 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
459 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
388 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
423 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
188 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
53 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
290 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
148 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
49 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
58 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
107 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, ...
1
vote
0answers
306 views

How to display non-hierarchical attributes on same row using Excel Powerpivot?

Using an Excel 2013 ProPlus PowerPivot pivot table, I have the following: (+ indicating a drill-down point) +Attribute-1 +Attribute-2 Attribute-3 Attribute-4 Below is what I would like to ...
1
vote
0answers
101 views

Auto-linking an outlook template to an excel chart

I need to send out data chart from excel on a daily basis. I would like to create a template that automatically updates the chart when opened. I am thinking there has to be a way to create a macro ...
1
vote
0answers
140 views

Pull Data From Web Database With Excel 2007

I have a web based database that I work with regularly that uses 802.1x authentication (Smart Card with password). From the website you can pull premade and custom reports that are ultimately stored ...
1
vote
0answers
851 views

Keyboard Shortcut to Fit Column Width to Text in Mac Excel?

I know this on a PC. It is Alt+O,C,A, as explained in this question. Can someone tell me please what the keyboard shortcut is to fit the column width to the width of the text in Excel on a Mac? I'm ...
1
vote
0answers
24 views

Paste graphs using paste link

I am copy and pasting graphs I have created in one workbook to another using the paste link function. It was working great but suddenly stopped working= the paste link won't show up as an option and ...
1
vote
0answers
93 views

Changing size of linked Table of Contents from Word to Excel

I have a Table of Contents in Word that I've linked to an Excel document. It works great, updates appropriately except for one problem. If I have a section in my Table of Contents, let's say 11.1, and ...
1
vote
0answers
58 views

Copying Tables from a Website

I have difficulty making an Excel-readable file from a table on a Website. The problems very specific to my question are: I have to use IE 7 to access the site. Excel is installed in another ...
1
vote
0answers
80 views

Excel (pivot) diagram to connect dots in a curvediagram no matter if an entry is missing

I have this pivot diagram, and I want to make a nice curve diagram, but I have some different entry points. For instance I have an entry for 3 of my series on 2008-november, but not for the fourth, ...
1
vote
0answers
601 views

Excel/Word on MAC - includepicture containing url

I have the following: A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code. A word doc where these names and ...
1
vote
0answers
250 views

What is the best way to create charts of “database-style” tables and data in Excel?

I'm a biologist and I frequently have to do analysis on relatively large (for Excel) datasets. Usually a few charts are needed to display the data, but creating them seems to require laying out out ...
1
vote
0answers
126 views

need excel files to be opened and maximize and always be opened

our computers in our company always turn on and we dont restart them... (if need hibernate them) some excel files in network drive shared and we want to open all over the time in some PCs which of ...
1
vote
0answers
157 views

How to name and save the file using the contents of a single cell

How to name and save the file using the contents of a single cell OR multiple cells I want to populate a cell with the contents of 3 other cells and then use that cell as the file name example ...
1
vote
0answers
119 views

Maintaining subscript format when copying a cell

How do I copy/lookup/drop down list a cell with subscript format? EXAMPLE: Phosphate (P2O5) should have the 2 & 5 in subscript but always returns without it.
1
vote
0answers
357 views

Cannot access password protected Excel worksheet although I know the password

I had some changes to make to an Excel workbook that manipulates some other Excel files, formats the data appropriately and then uploads the data to a server. The VBA code for the macro is protected, ...
1
vote
0answers
493 views

What format can I use in Excel to display both date and time in system formats

I need to display both date and time in system date and time formats. I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...
1
vote
0answers
739 views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
1
vote
0answers
234 views

Add Excel column without breaking equation

I have completed a very complex Excel spreadsheet with a lot of equations, except I forgot to include September. I have January through December, all the months, except the calculations for ...
1
vote
0answers
597 views

Excel changing decimal places on number cells when I edit the cell's formula

I have a worksheet with thousands of number cells, all formatted "Number, 3 decimal places, use 1000 Separator ( )". Starting a few days ago, if I edit a formula in any of these cells to reference ...
1
vote
0answers
1k views

Excel - Avoid cell text to be shown onto next empty cell

When you have text in an Excel cell that is too long to be shown in the visible area of a single cell and the cell next to the first cell (the one on the right) is empty, Excel lets the text to be ...
1
vote
0answers
115 views

Encrypt Excel file on Windows for use on Mac

I have an Excel file open using Excel 2007 on a Vista PC. I wish to encrypt this file, and send it to someone to open on a Mac running Excel 11.6.6 (Office 2004). Is this easily achievable? I ...
1
vote
0answers
59 views

Conditionally generate Excel sheet

I currently have an excel sheet that is used to record daily a bunch of parameters. Currently, I have a folder for each year, containing a folder for each month, inside of which I have an excel file ...
1
vote
0answers
246 views

Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters ...
1
vote
0answers
128 views

How to analyse data from several sheets with similar structure?

This is essentially Excel, merge two sheets with one column as key but instead of one key column I have 3 so I cannot simply use VLOOKUP. What I want is very simple: dynamically generate a master ...
1
vote
0answers
246 views

insert calculated field in pivot table based on previous row of one column

I want to create a calculated field BookCnt_Diff which would be row1-row2 and if RPT DT = grand total then 0.. this data is the result of a query which looks back 6 months so I want to be able to ...
1
vote
0answers
49 views

How to search unique dynamic data in a sheet and then copy relevent row in diffrent sheet?

I am getting data from internet (Data>From Web) In sheet1. Then I disperse that data in to three sheets based on three unique text. Like a,b and c. Rows are copied to sheet a,b and c sheets depending ...
1
vote
0answers
170 views

Updating one sheet and having it carry over to another sheet

I have a workbook that contains 2 sheets. One is a master forms list and the other is a log for document control changes. What I would like to have happen is, when I make a new entry into the ...
1
vote
0answers
980 views

Revision clouds in Excel

I was looking for an easy way to make revision cloud in Excel (20XX). I currently do it using a very weird copy/paste method, but it takes way too long! I recently stumbled across an Excel toolbar ...
1
vote
0answers
36 views

Excel 2002 (sp3) rewrite URI to an addin

I have a workbook which has a reference to an Excel addin. The addin lives on a network drive. So when I add the reference, the path of the reference is something like ...
1
vote
0answers
893 views

How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this? The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...