• What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?

    I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script...

    Dannl10 pointsBadges:
  • COUNTIF command using Excel and s comma-delimited file

    I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn't recognize the text info. For example, countif(xx:xx,"abc"), it wouldn't recognize the abc cells. Can you help me?

    Cklv5 pointsBadges:
  • Excel 2003 to 2007 Link Issue

    We purhcased a new pc and it came with excel 2007. After moving our documents (excel 2003) we were no longer received the LINK update request. The only way our linked documents work is if we open each one, then open our document to be updated. Is there something we need to change? We would like it...

    SWMPC5 pointsBadges:
  • Excel 03 won’t release cell

    We've had a couple of users run into issues with Excel 03 not releasing a cell as if were in EXT mode. Problem is that when we press F8 it won't release it. ESC hasn't helped and it locks up the workbook so the only way to close it is through Task Manager. Running Windows XP Pro SP2 with MS Office...

    Littlejuanito7420 pointsBadges:
  • Excel to Access conversion

    When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

    QAMAN15 pointsBadges:
  • Upgrading from excel 2003 to 2007

    After upgrading our laptops from Office 2003 to Office 2007 somehow the permissions in the IFS have changed and certain groups can no longer save Excel documents with system i data. They get a "cannot save" message. Any idea where to look? Netserver etc.?

    Kbordner5 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 pointsBadges:
  • I am getting “compiler error in hidden module” error in Excel 2003 while running Macro

    I am getting :"compiler error in hidden module " error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !

    Shirishbidarkar5 pointsBadges:
  • Excel macro between worksheets

    I have an Excel Workbook with a "Paid" sheet and an "Outstanding" sheet, both sheets have a File Number column. I would like to create a macro that looks through the "Outstanding" sheet and if the File Number from the "Outstanding" sheet is also in the "Paid" sheet can the entire row be deleted...

    Adavidson5 pointsBadges:
  • Since applying Outlook 2007 – Excell 2003 has Sharing Violation

    I have a user who has office 2003, i upgraded their outlook 2003 to 2007. When the user is in an Excel 2003 document and saves changes, occasionally she will receive a Microsoft Excel message box (not all the time) The message reads; Your changes could not be saved to 'ACCREXP.XLS' becuase of a...

    Jdroege10 pointsBadges:
  • Import text from another excel workbook

    I have a excel workbook (wb1) where the columns is showing the months and the rows is showing different actions that take place. If an action takes place in a specified month the cell corresponding to both the action and the month is marked yellow. In another workbook (wb2) I want to be able to...

    AenE15 pointsBadges:
  • To connect to Excel 2007 using free version API Java

    Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API's are in the Beta version. Guys any API's are there to support Excel 2007 ......

    Ansipar288315 pointsBadges:
  • 2003 Excel crash

    Excel 2003 crashs when opening a Excel 2000 spreadsheet with graphs. Recovery removes the graphs.

    Prthibodaux5 pointsBadges:
  • Excel Error

    I have been experiancing this error with/in excel; "Compile error in Hidden module: TFworkbook When I remove a internal templet "EY TAS datebook" the error disappears. The problem is that I need to have the templet. The box that pops up is a visual basic box does anyone have a suggestion

    Rjk10 pointsBadges:
  • How can i transfer more than 16384 records into Excel2003

    Hi All, I am trying to transfer a table with more than 20,000 records from access2003 to Excel2003, The code i am using within VB goes like this Private Sub Allstock_excel_Click() Dim filename As String filename = "D:\Automotive_Rapore\Archives\AllstockReport\Allstock_" & Format(Now,...

    Kentster5 pointsBadges:
  • export the data from excel into a database

    Hi Is there a way to transfer the data in excel sheet into a table in any databse with the use of ODBC connection?

    Jacky160 pointsBadges:
  • excel formula

    i am working on a worksheet and need totals from a prior worksheet, for one cell i use =sheet2!A3, when i try to get the total from A3 and A4 i do not get the total, i have tried =sheet2!A3+A4, but that does not work, please help

    Clw5 pointsBadges:
  • Switching Excel Custom Views Based on Selection

    I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited...

    Brgbldr5 pointsBadges:
  • Cannot Open Older Excel Files with 2003

    When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???

    Reap5 pointsBadges:
  • Deleting all formulas in a worksheet when unprotected in VBA code

    I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

    Barnoldswick5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following