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....
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....
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...
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...
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?
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?
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
How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007
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...
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...
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...
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...
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.
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.
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
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
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.
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.
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...
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...
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
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
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?
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?
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
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
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...
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...
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...
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...
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
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
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?
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?
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
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
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?
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?
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...
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...
