SQL 2005 SSIS 64 bit EXCEL
How do you configure driver to read EXCEL 2003 for SSIS on 64 bit SQL Server? How do you configure EXCEL 2007 for SSIS on 64 bit SQL Server?
Answer Question
| March 2, 2010 3:00 PM
Excel 2003, Excel 2007, SSIS 2005
How do you configure driver to read EXCEL 2003 for SSIS on 64 bit SQL Server? How do you configure EXCEL 2007 for SSIS on 64 bit SQL Server?
Answer Question
| March 2, 2010 3:00 PM
Excel 2003, Excel 2007, SSIS 2005
Imbed and Link External Excel Spreadsheet into Visio
Looking to utilize an external spreadsheet which maintains various information pertaining to our move from one data center to another. Items included are ip address, rack, U, hostname. The question is I want to utilize this spreadsheet as my source. Then within my Visio, I have tabs for each Rack. Within each Tab, I want [...]
Answer Question
| February 25, 2010 7:48 PM
Excel 2007, SharePoint 2007, Visio 2007, Windows 2003 Server
Looking to utilize an external spreadsheet which maintains various information pertaining to our move from one data center to another. Items included are ip address, rack, U, hostname. The question is I want to utilize this spreadsheet as my source. Then within my Visio, I have tabs for each Rack. Within each Tab, I want [...]
Answer Question
| February 25, 2010 7:48 PM
Excel 2007, SharePoint 2007, Visio 2007, Windows 2003 Server
Re-linking data source in Word 2007
I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is that when I Copy-Paste [...]
Answer Question
| February 18, 2010 11:37 PM
Data Sources, Excel 2007, Mail merge, Microsoft Excel, Microsoft Word, Word 2007
I have a bunch of word documents that are linked to an Excel spreadsheet (master sheet) for mail-merge reasons. Now all these documents are templates on a server. I need to Copy-Paste the entire folder (Including all documents and the Excel sheet) onto my computer before editing them. My problem is that when I Copy-Paste [...]
Answer Question
| February 18, 2010 11:37 PM
Data Sources, Excel 2007, Mail merge, Microsoft Excel, Microsoft Word, Word 2007
Macro permission in 2007
As occurs in Excel 2003, I would like to have a dialogue box prompt me when I open a spdsht regarding whether I want the macros enabled. I have not found that option yet. Any suggestions?
Answer Question
| February 10, 2010 8:57 PM
Excel 2007, Excel 2007 macros
As occurs in Excel 2003, I would like to have a dialogue box prompt me when I open a spdsht regarding whether I want the macros enabled. I have not found that option yet. Any suggestions?
Answer Question
| February 10, 2010 8:57 PM
Excel 2007, Excel 2007 macros
Opening a file from a program vs. from a folder
We have a shared folder on our server where we store spreadsheets, documents, etc. It uses Server 2003 Small Business. If I search for a file using explorer and try to open it, there is usually a decent amount of lag before it opens. If I open the program and search to open the file [...]
Answer Question
| December 3, 2009 6:18 PM
Excel 2007, Microsoft XP, public folder, Server 2003, Word 2007
We have a shared folder on our server where we store spreadsheets, documents, etc. It uses Server 2003 Small Business. If I search for a file using explorer and try to open it, there is usually a decent amount of lag before it opens. If I open the program and search to open the file [...]
Answer Question
| December 3, 2009 6:18 PM
Excel 2007, Microsoft XP, public folder, Server 2003, Word 2007
Excel 2007 – gauge, speedometer, or dial charts….
Hi, Does anyone have any idea were i could find some some sample templates on these 3 for : Excel 2007 – gauge, speedometer, or dial charts…. Thx Jared~
Answer Question
| May 13, 2010 8:22 PM
Excel 2007, Microsoft Excel
Hi, Does anyone have any idea were i could find some some sample templates on these 3 for : Excel 2007 – gauge, speedometer, or dial charts…. Thx Jared~
Answer Question
| May 13, 2010 8:22 PM
Excel 2007, Microsoft Excel
Can data on a second sheet be pulled up by a cell on sheet 1?
Hi… I work in an Emergency Room, and I’m trying to set up either a formula or macro so that when I’m making the “Call List” for the day I can type out the doctor’s name in the “A” column, and in the “C” column of the same row have the phone number for the [...]
Answer Question
| November 28, 2009 8:51 AM
Excel 2007, formulas, multiple sheets
Hi… I work in an Emergency Room, and I’m trying to set up either a formula or macro so that when I’m making the “Call List” for the day I can type out the doctor’s name in the “A” column, and in the “C” column of the same row have the phone number for the [...]
Answer Question
| November 28, 2009 8:51 AM
Excel 2007, formulas, multiple sheets
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. Please provide some inputs .. [...]
Answer Question
| November 17, 2009 12:47 PM
Excel 2007, Microsoft Excel, Microsoft SharePoint, MOSS 2007, SharePoint 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. Please provide some inputs .. [...]
Answer Question
| November 17, 2009 12:47 PM
Excel 2007, Microsoft Excel, Microsoft SharePoint, MOSS 2007, SharePoint 2007
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 years and [...]
Answer Question
| November 23, 2009 7:36 PM
Date calculation, Excel 2007, Excel Calendars
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 years and [...]
Answer Question
| November 23, 2009 7:36 PM
Date calculation, Excel 2007, Excel Calendars
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?
Answer Question
| November 13, 2009 1:12 PM
Excel 2007, Microsoft Excel, SAP BOM, SAP to Excel
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?
Answer Question
| November 13, 2009 1:12 PM
Excel 2007, Microsoft Excel, SAP BOM, SAP to Excel
How to export excel data to Sql server 2005
How to export excel data to Sql server 2005
Answer Question
| August 10, 2010 11:04 AM
Excel 2007, Exporting Excel to SQL, Microsoft Excel, SQL Server 2005
How to export excel data to Sql server 2005
Answer Question
| August 10, 2010 11:04 AM
Excel 2007, Exporting Excel to SQL, Microsoft Excel, SQL Server 2005
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 [...]
Answer Question
| October 23, 2009 7:21 PM
AS/400, Excel 2007, Transfer Data To iSeries
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 [...]
Answer Question
| October 23, 2009 7:21 PM
AS/400, Excel 2007, Transfer Data To iSeries
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 [...]
Answer Question
| October 9, 2009 9:09 PM
AS/400 - DDS, AS/400 data transfer, DDS, DDS Server, Excel 2007, Excel to iSeries, Exporting AS/400 to Excel, Microsoft Excel
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 [...]
Answer Question
| October 9, 2009 9:09 PM
AS/400 - DDS, AS/400 data transfer, DDS, DDS Server, Excel 2007, Excel to iSeries, Exporting AS/400 to Excel, Microsoft Excel
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.
Answer Question
| February 26, 2011 1:34 PM
Excel 2007, Microsoft Excel, SAP, SAP Export to Excel
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.
Answer Question
| February 26, 2011 1:34 PM
Excel 2007, Microsoft Excel, SAP, SAP Export to Excel
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
| January 23, 2012 6:46 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
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
| January 23, 2012 6:46 AM
AutoNumber, Excel 2007, Excel VBA, VBA, Visual Basic for Applications
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.
Answer Question
| June 22, 2009 2:09 PM
Excel 2007, Excel macros, Microsoft Excel
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.
Answer Question
| June 22, 2009 2:09 PM
Excel 2007, Excel macros, Microsoft Excel
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 [...]
Answer Question
| June 9, 2009 3:36 AM
Date conversion, Excel 2002, Excel 2007
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 [...]
Answer Question
| June 9, 2009 3:36 AM
Date conversion, Excel 2002, Excel 2007
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
Answer Question
| June 3, 2009 8:23 PM
Client Access, Excel 2007, iSeries Access, Microsoft Excel, Transfer Data To iSeries, V5R4
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
Answer Question
| June 3, 2009 8:23 PM
Client Access, Excel 2007, iSeries Access, Microsoft Excel, Transfer Data To iSeries, V5R4
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?
Answer Question
| May 8, 2009 2:15 PM
Excel 2007, Microsoft Excel
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?
Answer Question
| May 8, 2009 2:15 PM
Excel 2007, Microsoft Excel
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
Answer Question
| May 14, 2009 5:19 PM
Excel 2007, Excel formulas, Microsoft Excel
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
Answer Question
| May 14, 2009 5:19 PM
Excel 2007, Excel formulas, Microsoft Excel
