Excel 2007 Questions and Answers

Recent IT Questions

1 - 20 of 74
<<PREVIOUS 1|2|3|4 NEXT>>

Is it possible to export gantt chart view to excel 2007 in MOSS 2007?

Hello All,               Is it possible to export gantt chart view to excel 2007 in MOSS 2007?              Now i am trying to export gantt chart view but i am getting only columns in excel sheet. my requirement is i want gantt chart view with list columns in excel sheet....

Answer Question   |  Nov 17 2009  12:47 AM GMT
SharePoint 2007, Excel 2007, Microsoft SharePoint
asked by NASE

  5 pts.

Finding Seasonality for a large number of items in Excel.

I am trying to establish any seasonality with what is, unfortunately, a large number of items and a relatively small time sample.  I have 32,000 different items which have typically sold at a steady pace over the past three years.  I have the sales of each item by month for the previous three...

View Answer   |  Nov 11 2009  7:36 PM GMT
Excel 2007, Date calculation, Excel Calendars
asked by XENOPHON22

  185 pts.

BOM Download To Excel For I&PD Exercise

Are there easy directions for me to download from the SAP BOM's comprising 7000 lines to Excel for manipulation and pivoting of the data?

View Answer   |  Nov 10 2009  1:12 PM GMT
SAP BOM, Excel 2007, SAP to Excel
asked by NDIRISH

  5 pts.

How to export excel data to Sql server 2005

How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007

View Answer   |  Oct 29 2009  11:04 AM GMT
Excel 2007, Exporting Excel to SQL, SQL Server 2005
asked by Rasheed180207

  5 pts.

Upload Spreadsheet to AS400 using Excel addin - creates graphic fields for alpha fields

I am using the Excel addin to transfer excel files to our AS400.  The file does not exist on the AS400 and when the transfer runs, the field created for the alpha fields is 'Graphic' when I display the file field definitions.  I cannot read these fields in my RPG program - they are only text...

View Answer   |  Oct 20 2009  7:21 PM GMT
AS/400, Transfer Data To iSeries, Excel 2007
asked by PaulClemens

  25 pts.

Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows

I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date add on for excel 2007? 2. My...

View Answer   |  Oct 1 2009  9:09 PM GMT
AS400 - DDS, AS/400 data transfer, DDS
asked by Ringside

  35 pts.

SAP export to Excel 2007

when exporting a spreadsheet to excel 2007, currencies show in the wrong format (ie. 1,882,456.96 shows as 1882456:96). I've tried to format the cell but this does nothing. Also I've verified switching the regional settings but no luck there neither. Help will be trully appreciatted, Max.

View Answer   |  Aug 5 2009  1:34 PM GMT
SAP, SAP Export to Excel, Excel 2007
asked by Duscher

  5 pts.

how to create autonumber

while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

Answer Question   |  Jul 10 2009  6:46 AM GMT
Excel VBA, VBA, Visual Basic for Applications
asked by Army

  100 pts.

Run a Macro in Excel 2007 spreadsheet located on a file server

When I run the macro located on the local drive it works, but when I put the document out on a shared file server I get an error. The server folder is in my trusted locations.

View Answer   |  Jun 19 2009  2:09 PM GMT
Excel macros, Excel 2007, Microsoft Excel
asked by Njasche

  5 pts.

Separating dates into year, month and day componrents

I have an excel file of some 80,000+ records, one of whose columns - C- is in date - YYYY/MM/DD form. I want to split off the date into separate columns of years and months. I've managed to split off the years by using the expression LEFT (C2,4) where C is the label of the column containing the...

View Answer   |  Jun 9 2009  3:36 AM GMT
Excel 2002, Excel 2007, Date conversion
asked by Rogerc

  5 pts.

File Transfer to iSeries from Excel 2007

I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

View Answer   |  Jun 3 2009  8:23 PM GMT
Transfer Data To iSeries, Excel 2007, iSeries Access
asked by Badkarma

  40 pts.

Wildcard Characters

I have a formula to search for a code and return results. The problem is that within the code there are wildcard characters. How do I make wildcard characters searchable text?

View Answer   |  May 7 2009  2:15 PM GMT
Excel 2007, Microsoft Excel
asked by Shultzie

  5 pts.

Excel 2007 - how to add a average formula to that cell/s that ignoring 0%'s

Ok i figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s THis is what i had.... =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thx Jared

View Answer   |  Apr 30 2009  5:19 PM GMT
Excel 2007, Excel formulas, Microsoft Excel
asked by Jreifenstein001

  115 pts.

Excel 2007 Large file issues

I use Excel 2007 to do a fairly large multidepartmental Financial forecast and results package. The file size is currently at 48,000 KB and will continue to grow. I have this file open along with others of its size at the same time during use. Frequently Excel will crash during an autosave, when...

View Answer   |  Apr 30 2009  3:38 PM GMT
Excel 2007, Microsoft Excel
asked by Excelguy

  5 pts.

Excel 2007 - How do I ignore zero %'s for a graph?

Excel 2007 - How do I ignore zero %'s for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2. But then you...

View Answer   |  Apr 29 2009  6:49 PM GMT
Excel 2007, Excel formulas, Microsoft Excel
asked by Jreifenstein001

  115 pts.

Macro to breakout data into separate tabs

I have a weekly report that holds line item detail for seven different account numbers. The data is going to vary from week to week and I need vba code that will separate the data by account number into different tabs. Any tips on how to write the code? RWC

Answer Question   |  Apr 24 2009  0:11 AM GMT
Excel macros, VBA/VB, Excel 2007
asked by HNAvigator2009

  5 pts.

Excel Calendars

I have a schedule and would like to put the current months calendar as well as next months with cells that I can add info to for each day. Currently someone has to update the dates from month to month. Is there a way to have the calender update by just changing the Month and 1st date?

View Answer   |  Apr 23 2009  5:58 PM GMT
Excel 2007, Microsoft Excel, Excel Calendars
asked by Sandman007

  30 pts.

Excel 2007 - How to find duplicate data and sort into a row

I have two column. I would like to find the duplicate data and sort the int a row. Eg: Name Name2 Julie Jane Sally John Jack Paul Jane Sally The result: Name Name Julie Sally Sally Jack Jane Jane John Paul Pls help

asked by Miya

  30 pts.

VLOOKUP in Excel 2007

I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

View Answer   |  Apr 16 2009  10:57 PM GMT
Excel 2007, Excel VLOOKUP function, VLOOKUP
asked by Newkid47

  35 pts.

vba recorder issue

When I run excel 2007 and try to record a macro, it will not record any commands for inserting a wordart or editting the text of the wordart if one is already created on the spreadsheet. I am at a loss to determine the right commands without the recorder, and I can't figure out why it will record...

Answer Question   |  Apr 10 2009  11:28 PM GMT
VBA, Excel VBA, Excel 2007
asked by Lostinspace2000

  5 pts.

1 - 20 of 74
<<PREVIOUS 1|2|3|4 NEXT>>