Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X as part of the Microsoft Office suite. A new user-interface design, dubbed the "ribbon", was introduced with Excel 2007 for Windows. A similar UI was introduced to Excel 2011 ...
1
vote
2answers
64 views
Excel 2007 opens with only one worksheet
In Excel 2007, when User A creates a new workbook, there is only 1 worksheet for the book. When user B creates a new workbook, there is the standard 3 worksheets for the book. How do I get this back ...
0
votes
1answer
38 views
How can I search by SearchFormat in the wildcard text in Excel?
For example, there are 100(row) x 20(column) cells in a sheet, and every single cell has 5 lines. Some lines are in red, some are marked with strike-through, etc. How can I search all lines in red? ...
1
vote
2answers
21 views
Excel: Remove Duplicate Table Filters?
I have an excel spreadsheet in which I have created a table. I have a heading called "Location" which I have applied filters to. When I click the checkbox on this heading which allows me to apply ...
-1
votes
0answers
29 views
Issues with my SelectionChange [migrated]
I can't seem to get it to work right
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim LastRow As Long
If Not Intersect(Target, ...
2
votes
1answer
50 views
How to create a new group of radio button in Excel without interference?
Status:
I have a form with sections on the same page, in each section the user can only chose one solution. I'm using group of radio buttons on Excel 2007.
Problem:
When I ad a new group, the buttons ...
0
votes
1answer
21 views
Excel: How to plot a stacked scatter set
I have two datasets that share the same x values, but each have different y values.
I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...
0
votes
1answer
25 views
Step line pivot chart excel
I have a line overlaid on some bars in a pivot chart in excel, but I want the line to be stepped instead of curved. How can I accomplish this?
1
vote
1answer
34 views
Excel chart by date
I am trying to make a chart that represents our company's order forecast. I want the chart to be a pivot chart so that it automatically updates. I have a pretty in depth table that will be driving the ...
0
votes
1answer
28 views
How can I sum a series of tabs across tabs?
I have an excel 2007 file with 13 tabs (a summary and one for each month), and want to produce a sum up across the same cell for each month in the summary sheet.
I have tried ...
1
vote
1answer
32 views
Giving group indicators in Excel 2007 a name rather than numbers
This is a question relating to Excel 2007 - Can you give groups names?
Is there any way of giving the grouping indicators a name rather than using 1, 2, 3 etc?
0
votes
2answers
54 views
How to export file from excel (or other excel like software) to .CSV
I have 2 questions
Question 1.
Why is it when I try to export to csv file from excel 2007 I get a file that has a type of "Microsoft Office Excel Comma Separated Values File (.csv)"? I choose "Csv ...
2
votes
1answer
42 views
Highlighting references of a formula on multiple sheets in excel 2007
Is it possible to select a cell with references and have all of those references be filled at the same time?
I am working on a summary sheet and it has totaled all the cells of the various sheets ...
2
votes
1answer
47 views
Excel repeatedly changes cell number format to Text
I've used Excel more than I care to think about, but this is a new one for me. I have a cell with a simple formula, =Counts!E3. I set the number format to General. I edit the cell (just F2-Enter, ...
0
votes
1answer
40 views
Combine tables in several sheets to one sheet
I have an excel document with over 30 sheets. Each has the same layout: a simple table having the same columns, header/total rows, but different number of rows (none has more than 500 rows).
I want ...
1
vote
1answer
43 views
why does excel 2007 format date and “serial value” when applying the normal style
Why does Excel 2007/2010 remove the format of a date when applying the Normal style when it didn't in previous version?
For example, if I have 1/1/2012 and apply the Normal style, I end up with ...
0
votes
1answer
65 views
Excel 2007 Data Validation: Validate Against List or Allow User to Enter Custom Value
I know this kind of defeats the purpose, but is it possible to have an Excel 2007 spreadsheet with a cell that has:
Validate against a list that is column in the spreadsheet.
If not in that list, ...
0
votes
1answer
38 views
Excel: small horizontal window for showing expression is gone
I'm using both Excel 2007 and 2010 in two computers.
It's Excel 2007. I remember there used to be a horizontal window that shows the expression of the selected cell. But, as shown in the figure, ...
0
votes
1answer
109 views
excel cannot open the file xxx.xlsx' because the file format is not valid error
I have difficulty open opening word and excel files suddenly. Only particular office file give me the problem. These files were previously scanned by combo fix and I believe they were damaged. The ...
1
vote
2answers
66 views
Excel Spreadsheet for Barcode Scanning
I've been asked by our warehouse guy to help him with an excel spreadsheet to increase his productivity. The problem is, I'm not what you would call an "excel expert". What he wants sounds very ...
2
votes
5answers
86 views
How to reference a row value in a table in excel 2007 from another row such that sorting table doesn't change it?
Consider a table of employee name, age and employee manager. Employee manager is a reference to employee name in same table but different row. I tried this by referencing cell =A3
Now if I sort ...
1
vote
1answer
37 views
Install COM AddIn without adminstrative rights
I have a custome excel add in. I would like to install it on XP machine (to be added on Excel 2007). The problem I am having is that users don't have admin rights and also they have no permission to ...
0
votes
1answer
64 views
Stop “Excel formula or sheet contains the name” dialog
When I want to copy a sheet (within the same file, so simply using left mouse button and Ctrl) in Excel 2007, I get this pop up dialog:
where Author is a specific field somewhere in the sheet I'm ...
0
votes
2answers
62 views
How can I prevent the privacy warning in Excel?
I have Excel 2007. When I want to save a spreadsheet, I often see this message:
I've seen this with macro spreadsheets (using the .xlsm extension) and with non-macro sheets (using the .xlsx ...
2
votes
0answers
60 views
Lookups targeting merged cells - only returning value for first row
I have a master worksheet which contains data that I wish to link to another 'summary' sheet using a lookup.
However, some of the cells whose data I wish to include in the summary sheet are merged ...
3
votes
3answers
109 views
Excel formula for “select sum(B) where month(A)=3”
I have excel data as follows:
I want show the Total Cost for each month.
I can achieve this in Google Spreadsheets with the following formula:
=INDEX(QUERY(COSTS!$1:$1101,"select sum(B) where ...
0
votes
0answers
30 views
Finding ranges of duplicate data and determining beginning and end IDs [migrated]
I am using excel to keep track of certain data in the following form:
Date Name ID
1/01, A, 1
1/01, B, 2
1/02, C, 3
1/02, D, 4
1/03, E, 5
I want to set up a ...
1
vote
3answers
86 views
Hide cells when printing in Excel
I'm using Excel 2007. I have an estimate sheet, which I will use to keep track of client information. There is some low level information that the client shouldnt see on their version of the document. ...
0
votes
1answer
48 views
Trying to calculate damaged stock for individual items in excel
I have a worksheet (sheet 1) which looks like this:
item name | quantity | sold | damaged stock
keyring | 100 | 20 | 5
ball | 100 | 55 | 1
and another worksheet (sheet 2), ...
0
votes
2answers
56 views
Template is working for Excel2003 but not for Excel2007
I created an Excel worksheet (Book.xlt) under
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
with my own setting.
That settings are occurring only for Excel2003(.xls) ...
1
vote
1answer
32 views
Conditional formatting to highlight hlargest number
I've got several rows and columns of numbers. For each row I want to highlight the record that is the highest number or tied for the highest number in that row. I know how to do this for one row, ...
0
votes
3answers
44 views
Table data entry - How to always have a blank row at the end of an Excel table
I'm creating a simple Excel spreadsheet for table data entry (table created using the "Format as table" option -- couple of columns, there could be hundred of rows). I would like to always have the ...
0
votes
2answers
52 views
Excel file with link to (unavailable) file does not display
I have an Excel file (file A) with a link to another Excel file (File B). File B is on a SharePoint server that is no longer available and when I open file A it tries to connect to the missing ...
1
vote
2answers
79 views
VLOOKUP when Lookup Value is a cell populated via another formula
I need to perform a VLOOKUP, but the Lookup Value is a cell that is populated based on an other formula. The lookup is bringing me back a value of "#N/A". When I recreate the same values in another ...
1
vote
3answers
92 views
How to make upside down in MS Excel 2007?
How to make data upside down with a single click in MS Excel 2007 like shown in the below picture?
after making upside down
As well how to reverse it back with a single click?
0
votes
0answers
43 views
Excel 2007 OLE not available
My Excel 2007 gives this message (OLE not available) when I start Excel.
I have a windows service running which uses Microsoft.ACE.OLEDB.12.0 but that does close the resources afterwards and even when ...
0
votes
1answer
28 views
How do I partition an area graph?
I have the following data and the area graph with column2 and column3 is given below. I want to include the first column into the graph by partitioning the graph(using vertical lines probably or ...
1
vote
1answer
43 views
Microsoft Office Data Connection to utilise an external XML Data source?
I want to be able to process or product for connecting an external XML data connector to Microsoft Office Products (specifically Excel) so that it's seamless to the product. Essentially the ...
3
votes
1answer
97 views
How make this graph in Excel?
I'm trying to do this kind of graph in Excel, but nothing so far.
I don't find anything like it, but it has to be this way, not bars.
starter 22,58 20,76 7,1 37,93 68,42
professional ...
0
votes
1answer
81 views
Excel 2007 plot with labeled data items
I have data in the following format, where each label defines a row of data:
label1 x1 y1
label1 x2 y2
label1 x3 y3
label2 x1 y1
label2 x2 y2
label2 x3 y3
This is a very large data ...
0
votes
2answers
77 views
Pass values instead of range to VBA Function
I am creating VBA functions in Excel 2007. One has a prototype:
Function ToLevelCode_Range(val As Double, ByRef R As Range)
I can call it this way just fine and it gets the correct result:
...
-3
votes
2answers
142 views
What is the maximum allowed rows in a Microsoft Excel .xls or .xlsx
Is there a limit? I couldn't find one posted.
1
vote
1answer
159 views
What changed between Excel 2007 and 2010 that is causing my copied worksheet save to fail?
When I do this in Excel 2010 this fails, but works in Excel 2007:
Create a new workbook and insert an image onto a worksheet, or get a preexisting worksheet with an image.
Copy the worksheet into a ...
0
votes
1answer
98 views
Pasting HTML table into Excel 2007 without modifying the format of each cell
I have a table in HTML having cells storing numbers like 123.0,123.00. When I use ctrl-A to copy the whole page into excel, 123.0 and 123.00 are all changed to 123, which is not something I want to ...
0
votes
1answer
37 views
How to replace letters in a cell with defined numbers from a separate table
I have a cell which is has mixed numbers and letters(ex. AA12CC45WR) and they are random.
On another sheet, I have a table which has the equivalent for each letter like (cells A1, B1)
A=1
C=25
W=66
...
3
votes
1answer
63 views
How to automatically create Excel graphs from Access data
I have some data in Access from which I have to create Excel graphs every month (data would also be updated every month). So it's creating the same charts with different data every month.
Is there a ...
1
vote
2answers
107 views
Filter and reorder columns in Excel
I've got a service (phplist, a newsletter manager) that exports a user list with several fields. At the end of it, each user has one or more lists to which he has subscribed.
The problem is, that ...
1
vote
1answer
40 views
Export Excel settings to a file
I have customized Ms Excel to my needs, for example I have written small macros and attached them as buttons to the quick access toolbar, made the Developer tab visible etc.)
Is there any way to ...
2
votes
1answer
47 views
Populating cells with data from another spreadsheet after just keying in a few letters
I have 1 workbook with 2 spreadsheets. Spreadsheet 2 column A contains a long list of company names, Columns B - H contain critical information about the company.
Spreadsheet 1 contains all of the ...
2
votes
1answer
90 views
Recent files opened in Excel 2007 not appearing in the 'recent documents' list
I have tried:
Clearing out all the recent files opened with Excel by going to Office button -> Advanced -> Display Category -> Changing the "Show this number of Recent Documents" to 0, and then ...
0
votes
1answer
38 views
Linear interpolation in Excel 2007
I want to know how I can programmatic use my linear interpolate equation without having the user or myself to use the Goal Seek function in the data menu, well I could use the function but I want it ...
