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)

3
votes
0answers
71 views

Checkbox location changes when workbook is opened in Excel 2010

I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell. When I open it at work with Excel 2010, all the ...
2
votes
0answers
85 views

How to interpolate a graph with multiple series in Excel?

I have a X-Y scatter plot in Excel 2007 with multiple lines on same plot like a series for 2%, and other series for 3% and 5%. How can I interpolate such data? For example, if I want to know a value ...
2
votes
0answers
31 views

Excel 2007 on Win 7 Home Edition — failure to sum numbers when pasted from other source

I copied/pasted columns of numbers from my bank statements into Excel. When I try to sum groups of numbers, it does not sum them. Matter of fact, when I select a group of cells with numbers, it does ...
2
votes
0answers
59 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
238 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 (x86)\...
1
vote
0answers
28 views

How to add data vertically while xtracting tables from web page to excel

My code Public Sub Raju() Dim alertTime As Date alertTime = Now + TimeValue("0:05:00") ' ' mymacro Macro ' Dim ws As Worksheet Set ws = Worksheets("Sheet1") ...
1
vote
0answers
8 views

Excel work tabs sharing data

I'm working with Excel; in tab 1 (Data Sheet) I have lines of data, each line represents a part with all its history and associated cost. the 2nd tab pulls data from tab 1 based on particular columns ...
1
vote
0answers
86 views

How can I view the properties of a ComboBox on an Excel 2007 Worksheet?

A similar question has been asked and solved on this forum, but the solution offered there does not work for me. I have enabled the Developer tab, and clicked Design Mode, but still, right-clicking ...
1
vote
0answers
2k views

How can I create sub-sheets in Microsoft Excel?

I have a workbook in excel that displays information from multiple processes and each of these processes has multiple sub-processes. I can display information for each process easily using one sheet ...
1
vote
0answers
25 views

Control Number Generation

So currently I have the following. When I click a button or hit submit button The form looks on the Ledger Tab. I was trying to get the form to automatically generate a control number (ConNum) that ...
1
vote
0answers
129 views

Excel lookup value not on same row

What i`m looking for is that the data will be filled automatically from data table by lookup value in not same row. See the picture or xls example https://dropmefiles.com/BDlHe 1st table lookup ...
1
vote
0answers
112 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel 2007-2010)...
1
vote
0answers
120 views

Why am I getting an error in this Excel module that runs access queries and copies results to the workbook?

I have written a module in excel to run 6 access queries and copy them into the excel workbook. My code works perfectly until I get to the 5th and 6th query then I get the error; Run-time error '...
1
vote
0answers
41 views

Opening a file with a # in its path using the default application from Excel 2007

I have a pdf file which is located at "D:\some\#folder\filename.pdf". And want to open it from an Excel worksheet by clicking on a hyperlink (or something similar). Just creating a hyperlink does not ...
1
vote
0answers
141 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): =HYPERLINK(...
1
vote
0answers
262 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
413 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 ...
1
vote
0answers
25 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
488 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
322 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 ...
1
vote
0answers
525 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
175 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
89 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
65 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
37 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
61 views

Excel dates with standard format (*) become custom when opened in another country

Here in the USA, I have created an Excel 2007 spreadsheet with a table that contains several columns with dates. I have formatted the date columns using the standard short date format (with the ...
1
vote
0answers
132 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
273 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
76 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
121 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
65 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
91 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
225 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
393 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
331 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
140 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
1k 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
158 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
760 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
643 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
14 views

Defining a range in excel for index/match

I'm trying to return a "best" value, but there are two criteria for a threading calc. One column has stress, which just has to be higher than a given value, and the other would be where you want the ...
0
votes
0answers
44 views

without iteration condition, =A1+C1 in C1 cell,

I've tried iteration condition, but it is not taking only the 'A1' value, if I put some value in some other cell, C1 is calculating like =A1+C1 in C1 cell,means A1 value is 5, in C1 i put this farmula ...
0
votes
0answers
17 views

How to stop Excel “trying to connect to <my file server>” and make it just save the file?

Client: Excel 2007 on Windows 7. Server: Samba 4.1.17+dfsg-2+deb8u2 on Debian Jessie/AMD64 When opening files from a network location: Excel takes a very long time to start opening the file (...
0
votes
0answers
25 views

How do I add multiple date values?

I already used the function =IF(AG2<(TODAY()+2),"DELIVERY DATE",IF(AG2<(TODAY()-1),"DONE","ON GOING")) but the value of "DONE" is not working. Please help me out. This is the criteria: if ...
0
votes
0answers
10 views

Why is an embedded object in a hidden cell copied over when I copy/paste only visible cells?

I have embedded pictures in cells in my Excel 2007 workbook. I have already formatted all of them so they "Move and size with cells." The pictures are hidden when I filter in Excel. However, when I ...
0
votes
0answers
15 views

Excel SUMIFS Formula Sequential Date Criteria?

=SUMIFS($I$2:$I$2221,$M$2:$M$2221,"VISA",$B$2:$B$2221,"June 1") This is the formula I am using for a sales analysis worksheet, that takes the clutter from the POS report and breaks it down in a ...
0
votes
0answers
14 views

Refresh Excel Connection without source being open

Morning all, I have a query regarding refreshing Excel connections. I have a company workbook that has many sheets and is in constant use all day, however I have a connection created to this which ...
0
votes
0answers
13 views

List Sort with New Rows - Excel Macros

I am trying to record a macro that sorts my list, but am currently at a wall - I need this sort to adjust to my list depending on adding/removing rows. My current code scans the list for which cell ...
0
votes
0answers
34 views

Stumped with how to write Excel formula: How to check if multiple values in a single row are the same in two different sheets?

I'm sorry, I know that title must sound confusing but I'll try to explain it better here. Essentially, I have to check if a row in a Sheet2 has two of the exact same values in another row in Sheet1. ...
0
votes
0answers
9 views

Copying Conditional Formatting rule to range of cells and automatically updating the cell references

I wanted to apply Conditional Formatting to range of cells A2:A30 using a formula =Countif(A2:A$30,A2)>1. It works and gave the desired result. However when I go to any cell other than A2 and click ...