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
199 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
81 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
389 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
309 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
314 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
156 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
45 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
81 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
136 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
47 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
57 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
87 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
264 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
82 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
118 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
708 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
23 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
86 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
77 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
513 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
215 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
108 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
141 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
108 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
305 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
447 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
568 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
208 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
462 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
897 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
109 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
55 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
219 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
124 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
233 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
48 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
157 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
798 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
819 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 ...
1
vote
0answers
78 views

When Calculate is set to Manual, calculation still occurs

If you write in some arithmetic formulae interdependencies across several cells, they still update in responsive real time when an independent variable is changed, even if Formulas!Calculation Options ...
1
vote
0answers
238 views

VBA code not refreshing external query

I have a small Excel file with VBA. We use the task scheduler in Windows to open this small file which then runs a macro to open, refresh, and save various reports that we have automated. The file ...
1
vote
0answers
170 views

How do I connect a checkbox to include more than one cell of data?

I'm working on a matrix where you can compare products and their options to one another. I've created a macro linked to a data table in my workbook (titled portables). When you click the check boxes ...
1
vote
0answers
501 views

Transform two-dimensional tables to one-dimensional list in Excel

I am facing the task of querying about 20 parties for numerical data. I will do this via an Excel template. The Excel file is a table with a x (2...51) and a y (B...M) dimension. Data is to be filled ...
1
vote
0answers
2k views

Excel conditional formatting, greater than a year

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates. I would like if over 3 years ago, if over 2 years ago, if over 1, ...
1
vote
0answers
463 views

Excel shuts down in Windows 7

I have written an employee payroll program using Excel 2000. It runs fine on my computer running Vista. When I port it via a flash drive to a Windows 7 computer and run it from the flash drive, it ...
1
vote
0answers
295 views

Excel chart axis values are doubling up along the axis

Excel chart axis values are doubling up along the axis - how do I stop this happening? It is in both the primary and secondary scales. eg the axis shows 18, 20, 20, 22, 22, 24, 24, 25
1
vote
0answers
144 views

ms excel 2010 in windows xp - when open workbook the data is formatted differently than when i saved it

I haven't been able to find an answer to this. I have multiple files that I use regularly in excel that now have cell formats of "date". Every single cell in the entire workbook (all sheets) is ...
1
vote
0answers
88 views

Creating a script to make a CSV dump usable

So, let's say I have a raw CSV dump. And I want to make a spreadsheet/script to take said CSV dump, take a certain username, and the calls they made, and pipe those calls to a mathematical formula, to ...