Stack Overflow
Stack Overflow

Questions tagged [excel-2007]

The Excel-2007 tag is used for referencing the Excel Version 2007 spreadsheet application from Microsoft. The version independent Tag is "excel". If your question is about VBA then also tag it VBA. If it is about an Excel formula or worksheet function, then tag it worksheet-function.

Excel 2007 is the 12th version of Microsoft's commercial spreadsheet program. It is the first version of Excel to incorporate a new user interface (UI), which is now standard across most/all Office suite programs.

This tag is used for questions specific to the 2007 version of the program. However, it is usually used in tandem with other tags, to let SO users know what your question is about. If your question is about VBA then also tag it . If it is about an Excel formula, tag it or . Questions about addins for Excel 2007 should be tagged .

Links:

3668 questions
13
votes
1 answer

function which takes address() and gives value

I want to make a cell equal to the cell above it. When I write =address(row()-1;column()) It just writes the name of the cell above(for example for B2 it writes $B$1) Is there a function which inputs the address and puts the value?
a-z
  • 1,634
  • 4
  • 16
  • 35
13
votes
1 answer

How can I count data by group in excel

I have data of program usage in excel file, the data has date and time. I want to summarize this information that in each day each hour, how many user use this application. How to do that using excel formular? sample data: Jun 01, 09:03AM Jun 01,…
Anonymous
  • 9,366
  • 22
  • 83
  • 133
12
votes
3 answers

Deleting pictures with Excel VBA

How do I delete all the pictures in an Excel 2007 worksheet? A working code example would be great.
Arlen Beiler
  • 15,336
  • 34
  • 92
  • 135
12
votes
9 answers

Charts Do Not Automatically Update When Data Changes

Hopefully this is an easy one. I have a series of charts in MS Excel that point to data on the same worksheet. The data on the worksheet is calculated using a VBA function. When the data is updated by the VBA function the new numbers are not…
Adam
  • 1,011
  • 2
  • 19
  • 37
12
votes
3 answers

Excel 2007 - Wrap X-Axis Labels (line break, word wrap)

I am not able to wrap the text of x-axis labels on Excel 2007 charts. As a result, the axis labels are overlapping onto each other. Does anyone know how can I wrap these labels?
soldieraman
  • 2,630
  • 7
  • 39
  • 52
12
votes
5 answers

EPPlus Large Dataset Issue with Out of Memory Exception

System Out of Memory Exception. I see the memory Stream is only flushed when saved. We have 1.5 - 2GB Datasets. I am using EPPlus Version 3.1.3.0 We do the following in code. We loop through --> Create a Package --> each table in the…
bhushanvinay
  • 449
  • 1
  • 5
  • 21
12
votes
6 answers

Excel Formula which places date/time in cell when data is entered in another cell in the same row

Hoping there is a way this can be done with a formula since I will be putting this on SharePoint as a shared workbook. Column B contains Tasks, while Column E contains the Date and Time of when the Task was assigned. Is there a formula that would…
IndyMom83
  • 153
  • 1
  • 1
  • 6
12
votes
5 answers

using c# to select a worksheet in excel

Using C# in .NET 3.5 with Visual Studio 2008, I am trying to set focus (or activate) a specific worksheet in an open workbook: Here are some properties: public Excel.Application xlApp {get;set;} public Excel.Workbook xlWorkBook { get; set; } public…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
11
votes
3 answers

Delete duplicate items in Excel (including original value)

How to delete duplicate items in excelsheet(column), where it has to delete the items which has more than one occurrence: 1 2 3 3 4 4 If we use remove duplicate option, it will give distinct values, but what should be done to get only…
Punith GP
  • 690
  • 4
  • 11
  • 33
11
votes
9 answers

How to keep value of merged cells in each cell?

I created a sheet with merged cells, but the value of the merged cells is only stored in the first cell. Is there anyway, to keep the same value in each of the cells, I need that for a formula I use. Thanks!
Kinshuk
  • 113
  • 1
  • 1
  • 4
11
votes
1 answer

Architecture of an Excel application

after 10 years of programming I find myself with the daunting task of creating my first Excel application in Excel 2007. I have programmed in VBA before on MS Access so this is not really a technical challenge for me but it's a real change of…
Lorenzo
  • 4,558
  • 11
  • 44
  • 54
11
votes
6 answers

Prevent Excel from quitting

I'm missing an Excel.Application.Quit or an Excel.Application.BeforeQuit event. Does anybody know a workaround to mimic these events? I access Excel from a C# WinForms application via COM Interop. Given an Excel.Application object, how can…
chiccodoro
  • 14,407
  • 19
  • 87
  • 130
11
votes
4 answers

Add new lines in VBA email

I'm trying to send an email automatically through Excel, but the new line commands aren't working! I've tried
, vbCrLf and vbNewLine .HTMLbody = "Hello" & vbNewLine & "Please find attached the above invoices and backup" & vbNewLine & _ …
DannyBland
  • 483
  • 3
  • 10
  • 26
11
votes
8 answers

SI-prefixes for number format in MS Excel

Does anybody know if it is possible to show numbers in MS Excel with SI-prefixes? I'd like to have ... 1 n, 1 µ, 1 m, 1, 1 k, 1M, 1 G, ... instead of scientific format ... 1E-09, 1E-06, 1E-03, 1, 1E+03, 1E+06. 1E+09, ... Perhaps adding an unit…
jost21
  • 1,084
  • 3
  • 15
  • 29
11
votes
4 answers

VBA Macro across multiple worksheets

I am trying to run a single macro which performs functions on multiple worksheets. Let's say I have assigned the macro button on worksheet 4. I have listed the functions I want it to perform step by step: 1) Select certain cells in worksheet 4 and…
kmiao91
  • 303
  • 4
  • 11
  • 22
1 2 3
…
99 100