Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

2
votes
0answers
50 views

CTRL+SHIFT+DOWN not working in Excel 2007

Ctrl+Shift+↓ is not working in Excel 2007. I have unchecked: Options → Advanced → Tools → Options → Transition Navigation Keys Ctrl+Shift+↑ is working fine. If I ...
2
votes
0answers
1k views

Excel 2007 - cannot open the clipboard

Every now and then within Excel when I do Ctrl-x (cut) or Ctrl-c (copy) I get the pop-up message 'Cannot open the Clipboard'. I can't see any particular pattern to it but it's very annoying when it ...
1
vote
0answers
35 views

Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want): ...
1
vote
0answers
37 views

Filtering values on Excel Pivot Chart

I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold. For this, I click PivotChart filter and see that filter may ...
1
vote
0answers
15 views

excel 2007 MS Query

I have created a spread sheet using MS query. I have added several columns to the rows of data so there can be some manually entered notes at the end of each row. The problem is when I refresh the ...
1
vote
0answers
200 views

Percentage increase between two data points - bar chart / Excel

Please forgive me but I simply do not know how to include these arrow lines displaying percentage increase/decrease between two points on a bar chart in excel. I wish to replicate what is showing in ...
1
vote
0answers
215 views

Macro to copy multiple rows from one worksheet to another and then copy the headings into copied columns

I am new to macros and I have developed this macro that allows me to take rows that has data in them from cells B-G from Workseet "master 1" starting from row 11. I take this data and then copy it ...
1
vote
0answers
69 views

Align column of numbers, negative numbers, decimals and percentages in Excel

My list of numbers contains the following: 48.8 4.19 (0.36) 4.52% and I want them all to align by decimal. As far as I can tell it is not possible in a single step and the best I can do is paste ...
1
vote
0answers
639 views

vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...
1
vote
0answers
59 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
51 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
18 views

Embed an dotm file into an Excel document

I have a dotm file( macro enabled word template). I want to insert it into an Excel file and I want to open it by the clicking of a command button in Excel form. The problem is, when I open this dotm ...
1
vote
0answers
90 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
87 views

Excel: cannot remove advanced filter

I added Data->Sort&Filter->Advanced filter to a cell that allows me to quickly choose a name from a range of names stored in another sheet some time ago. Now I would like to remove the advanced ...
1
vote
0answers
65 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
72 views

Microsoft Excel hyperlink function to a specific location in a Word doc

I have a long column of numbers in Excel that I have mail merged to a Word doc. I would like to write a function in Excel that will hyperlink each cell from this column to its corresponding mail ...
1
vote
0answers
154 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
47 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
78 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
114 views

How to create a formula which finds a cell that matches a range of other cells then produces a number if the cell appears.

am having trouble with finding a suitable formula for my spreadsheet in excel. In column A i have a list of postcodes (439 postcodes). In column B-BL i also have postcodes (these postcodes are in ...
1
vote
0answers
205 views

How to disable PASTE in Excel without VBA

This is an old question - You can't really force validation rules in excel b/c even if you protect your sheet a simple copy/paste can bypass all validation (very strange implementation of protection ...
1
vote
0answers
248 views

Microsoft Excel Copy one row to another worksheet if cell contains specific data

I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". ...
1
vote
0answers
98 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
805 views

How can I extract images from an Excel sheet, and control their file names?

I have an Excel sheet with the following columns Product ID Product Name Images Images are placed on the worksheet but not in any cell. I want to extract the images as files (jpg, png, gif, etc) ...
1
vote
0answers
154 views

Include new rows in autofilter range

I am working with an excel 2007 worksheet that has the "filter" applied so that each column heading has a pull-down menu for sorting. When I add new rows to the end of the table by cut-n-paste from ...
1
vote
0answers
478 views

Excel Pivot Table - Change default font

Is it possible to change the default font for a Pivot Table? We have a report automation module in our application that populates an Excel spreadsheet with a result set from an Oracle SQL query. ...
1
vote
0answers
579 views

Pivot Tables: how can I stop my columns from disappearing if they are empty?

I've ticked 'preserve cell formatting on update', but if one of the columns doesn't have an entry then it disappears. Is there any way I can keep it from disappearing even if it's blank? I suspect not ...
0
votes
0answers
8 views

Auto copy formula in Excel 2007 to next sheet

I run an extremly Large Data qry every morning and dump it into a multi sheet excel file, in that file i have a Sheet set up for just formulas to copy from. Currently i manually copy these formulas ...
0
votes
0answers
19 views

Query/Reports in Excel only

I'm trying to use Excel in a way probably more suited for Access. Unfortunately I have no access to Access or Visual Studio (outside the VB prompts in excel.) I have an excel "database" with several ...
0
votes
0answers
7 views

When moving data in Excel, how do I get data validation from destination

I have a workbook with three sheets, Active, Finished, and Tables. Tables contains auxiliary Tables for data validation. At some point a row in Active will be moved to the Finished sheet. Both those ...
0
votes
0answers
37 views

Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS). The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model). Let's say I have ...
0
votes
0answers
21 views

How do I copy/referrence last value of the column from another file and worksheet

I have two spreadsheets - one is the inventory sheet that gets updated with sales and purchases, and the other spreadsheet is where I want to reference or copy the ending inventory as soon as it gets ...
0
votes
0answers
16 views

Excel 2007 document form button not working

I have a file which works fine on one user account, but not on other. Both users are logging into the same PC. What happens is that when the file is open and we click on the form button, it should ...
0
votes
0answers
42 views

excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014". The receipts have client names for each row (each row is a receipt). The search key is in the "Clients 2014" worksheet. I want to ...
0
votes
0answers
15 views

Tex-style keyboard shortcuts for inserting symbols to MS Excel and Word documents

I've used Latex before in Linux and I loved it. My favourite thing about it was the reliance on the keyboard. For example, if I wanted to insert a 'sigma' symbol, I would simply type '\sigma' and when ...
0
votes
0answers
23 views

Excel formulae to select cell and cell header

I have a spreadsheet of student data. I want to be able to look up a student and return the grades for the students with the subject header. Students do not take all the subjects. Name Maths ...
0
votes
0answers
29 views

Error when running a VBA in Excel

I am trying to merge 150.000 different .xls files into one only one master sheet. I have done this many times before but I am suddenly receiving a error in the middle of the process. Here is the VBA ...
0
votes
0answers
79 views

Excel 2010 shared workbook - image buttons disabled

I have several Excel workbooks which were originally created in a 2007 version. They are shared workbooks, and contain some VBA code, and are protected to prevent users from changing certain content. ...
0
votes
0answers
36 views

Formula to search two columns of a database and return value from different cell in the matching row

I am designing a spreadsheet for scheduling appointments. On one sheet I have all the data but the dates and times are not in chronological order. I am having trouble writing a formula that will ...
0
votes
0answers
20 views

Excel 2007 freezes hangs when I enter an email address

I don't know how this started. But anytime I enter an email address, excel freezes. It never responds no matter what option I choose. I have tried it with one cell and nothing else. I have tried it in ...
0
votes
0answers
49 views

Excel error – command sending fails

Everytime I double click .xls file I get error window: "There was a problem sending the command to the program". There is no problem if I open the file by “File-Open” command.. I tried to copy and ...
0
votes
0answers
26 views

How to have excel 2007 userform stay on top of all other windows

The title says it all really. I have a modeless form generated in excel 2007 that'd ideally stay on top of all other windows (not just excel). I know other applications can set this, but I'm unsure ...
0
votes
0answers
34 views

Sharepoint Excel file synchronization

I recently found a problem with Sharepoint and Excel with concurrent changes: Person A created an Excel file with, let say, 2k inputs and uploaded it to Sharepoint with website Person B did not open ...
0
votes
0answers
11 views

I'm trying this code to create a combobox to list all sheets when start a workbook on Exc 2007. But it's not working.Thanks in advance

Private Sub Workbook_Open() Dim oSheet As Excel.Worksheet Dim oCmbBox As MSForms.ComboBox Set oCmbBox = ActiveWorkbook.Sheets(1).cmbSheet oCmbBox.Clear For Each oSheet In ActiveWorkbook.Sheets ...
0
votes
0answers
101 views

Color scale based on multiple cells

I have a data sheet with min-max possible values adjacent to each other. I'd like to color the cells based on how close they are to matching (ie the color should be based on their difference) I ...
0
votes
0answers
50 views

How to optimize Excel 2007 cell width for printing?

I have an Excel spreadsheet with 5 columns. Two columns have cells which contain very little text (e.g., dates or prices) while three columns have cells which can sometimes contain several rows of ...
0
votes
0answers
31 views

Auto create folders using Excel field entries (using a template folder)

I need to generate folders for new job numbers that are generated in excel. Every time the excel sheet is updated with a new job number I need to generate a folder in a set location with the folder ...
0
votes
0answers
82 views

Using icon sets comparing values in two cells (excel 2007)

I am trying to place icon sets in cels with their value, comparing that value to the same data of last month. So for example I have column A contains this months rank (0-10) column B contains last ...
0
votes
0answers
114 views

Auto propagation of formulas down the columns for each new row

How to propagate those formulas down the respective colums for every new row automatically? There is an webhook which creates new rows with data with those columns (A1, X2, Y2) empty, and I would need ...
0
votes
0answers
299 views

Trying to get VLOOKUP to get data from a table array on another workbook where the worksheet name is variable

I currently pull data in from 4 workbooks using the INDIRECT function, the formula is as follows, =INDIRECT("'[" & $AE$1 & "]" & $AA$13 &"'!" & $AI$1) $AE$1 contains the workbook ...