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

copy data from multiple word files to excel with vba

I know this question was already asked (Copying data from multiple word docs into one excel sheet) the thing is I can't use the answer. I'm fresh to vba, but I thought I can handle it. I was wrong. I ...
2
votes
0answers
46 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
986 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
17 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
60 views

Getting Excel to “update” or “follow” a linked Access table?

I'm using Excel and Access 2007. I'm having an issue at work and my current knowledge of Access and Excel isn't enough. I have an Access database that has certain data in it. I have an Excel ...
1
vote
0answers
32 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
123 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
20 views

Looking up the same value in a row and returning multipe corresponding values

I am trying to lookup value 1 in the example below and return corresponding column name. When I use index match, it only looks up the first column which corresponds to 1 in the below example, it looks ...
1
vote
0answers
40 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
40 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
14 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
71 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
60 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
58 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
89 views

Microsoft Excel 2007: When trying to save - “File in use. Try again later”

When I open an Excel document from server, edit and then try to save the changed document, I get the message that "path\filename is in use. Try again later". I can use "save as" and save a new ...
1
vote
0answers
56 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
135 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
40 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
64 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
79 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
136 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
157 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
85 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
144 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
428 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
554 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
11 views

Continue from one excel sheet to other without merging them together

i have an Excel workbook whic contain monthly sheets of sales. Each monthly sheet contains sale figures for various items (in columns) on a daily basis. the days are grouped in weeks. Now i want to ...
0
votes
0answers
10 views

save a sheet in new closed workbook without links

I have this code which work pretty good but I have a problem that the new exel workbook have links from the old one. Sub archive() Dim FileExtStr As String Dim FileFormatNum As Long Dim xWs As ...
0
votes
0answers
45 views

Plot two time dependent series in Excel 2010 when the number of data points are different but start and end time are same

I'm trying to plot graphs for pressure and temperature recorded on different devices. The number of data recorded for each device is different (Eg. pressure has 1 reading per second while temperature ...
0
votes
0answers
29 views

How to get count in pivot table that does NOT count duplicate entries

I am setting up a pivot table, and I would like for it to give me the count of the number of unique combinations of two fields, not just the total count. That is, each combination should only be ...
0
votes
0answers
17 views

Hiding the Microsoft Query table properties in Excel

I have done a data connection in Excel using the "From Microsoft Query" data connection type. In that i have also set criteria where the values are taken from a particular cell. This is so that the ...
0
votes
0answers
13 views

Dynamic Scenario output in excel

I have a model where in the input numbers going into the model depend on the cases/scenarios i select from a drop down menu ( Base, Best and Worst). These numbers are then used across all remaining ...
0
votes
0answers
7 views

Splitting data in column a to column b and or c

I'm trying to find a macro that will help me in sorting data. This is a very large document and will be a regular (monthly) endeavor. I've looked and tried help but I'm no better off, lol. I've got ...
0
votes
0answers
70 views

vba excel macro runtime error 1004

Dim lastC As Long lastC = wb2.Worksheets(2).Cells(1, Columns.Count).End(xlToLeft).Column 'highlighted in debug SourceRange.Copy wb2.Worksheets(2).Cells(1, lastC + 1).PasteSpecial Paste:=xlPasteValues, ...
0
votes
0answers
56 views

Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...
0
votes
0answers
12 views

how do you modify default excel hotkey in excel 2007?

how do you modify default excel hotkey in excel 2007? In word 2007, under office -option-define-menu you can define hotkey and change exsiting hotkey, while in excel i can't find it.
0
votes
0answers
4 views

paste values in a cell based on two other cells

I have 2 columns(a,b) containing values. If cells in 'a' column have a string called 'major',then I have to paste 'important' in the corresponding blank cells of b. New to vb.Need help Thanks
0
votes
0answers
13 views

I am having trouble pasting my data from a html* filtered notepad doc into Excel

I am copying supplier stock items from their website into Word, then copying it into a HTML file and opening it in Notepad before copying it to Excel in order to keep the format of the original text. ...
0
votes
0answers
27 views

Excel Macro for preserving line breaks in cell text

I have an excel sheet containing text that I require copying and then pasting into a 3rd party application (bit like notepad). I need to use a button to copy the text so it cannot be edited or ...
0
votes
0answers
37 views

How do I make a function update dynamically when I make changes to the function in a “master” cell?

For example, column 1 would contain input data, and subsequent columns would perform actions on that data. Row 1 would be the master row. All changes to the formulas in row 1 would be duplicated ...
0
votes
0answers
42 views

Macro to copy values to new sheet and prompt user where they want to save

I'm looking to create a macro in Excel 2007 which will do the following: copy the formatting and values from a sheet called 'report', insert this into a new workbook, naming the file with the value ...
0
votes
0answers
17 views

Excel 2007 : paste from clipboard to visible rows only

What I want to do is to copy multiple lines from a .txt file and paste it into an excel sheet that have hidden rows. Each line on my text file is correlated to the same visible row on the excel sheet. ...
0
votes
0answers
55 views

Go to first non-negative cell in a row and divide by another cell

I'm looking to have Excel calculate the financial payback period for me. In words, I'm trying to count and return the first non-negative number in a row and divide that value by a corresponding cell. ...
0
votes
0answers
104 views

Excel 2010 Compile Data from Multiple Worksheets into Summary Spreadsheet

I've compile a structural steel and architectural finishes material take off for an industrial building. I simply tallied the quantity of each length of each shape on a sheet corresponding to each ...
0
votes
0answers
10 views

Excel group files not opening

The OS is Windows XP 2003 server and the program is Microsoft Office Standard 2007 (Excel). This computer recently upgraded from Office 2003 to Office 2007. Upon clicking any .xls or .xlsx book file ...
0
votes
0answers
81 views

Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...
0
votes
0answers
58 views

Microsoft Excel 2007 - Auto Update in 1st Sheet based on What updated in 2nd sheet (2nd sheet Update will be in Fixed Column but Random Row)

Actually I'm facing a problem now. I am using Excel 2007. And, I have two different sheet of excel file with me. My 1st sheet is my report. My 2nd sheet is my customer name. I hope that when ever ...
0
votes
0answers
44 views

How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form: Year Month Category Region ...
0
votes
0answers
30 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
0answers
36 views

EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example: In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell. In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...