Excel 2003

office 2003 excel filter

Within excel 2003 I have 1245 records in a sheet and I try to add an auto filter and not all items in that column are in the list, why. When I select just a few cells in the column and apply the auto filter the missing items are there but highlighting the whole sheet or just the entire column and...

What are Excel internal limit for size and formula complexities/

MS Excel 2003 and 2007 crash when handling oversized spreadsheets. The RAM memory is 4 gig and has plenty of memory. The machine is running Windows XP Pro. The spreadsheets have many calculations and formulas and have been set to Manual. Also have tried the 'control-end' on each sheet to no avail....

Problem refreshing excel 2003 ms query using excel 2007

I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...

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...

Excel 03 opens as Read Only always

We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks

Using Access query data in Excel

I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets some selection...

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.?

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?

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...

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 !

Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.

Is there a method to use the formula function to copy the contents entered in one cell (A2)into cell B2 with the addition of an asterisk '*' on both ends of the copied text? An example being - Enter 'H123456' in A2, with the output in B2 being '*H123456*'

minor loss of fidelity but cant find data!

I have a large database saved in xls. 2003; I changed one column heading and got a message that reads: Compatibility Report for Thurs Brkfst Data Base.xls Run on 11/20/2008 16:50 The following features in this workbook are not supported by earlier versions of Excel. These features may...

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...

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...

Microsoft Excel 2003 Macros

I am wondering if there is an easy way to remove macros from an Excel 2003 workbook. Several of our users have had emails with Excel attachments rejected due to the macros they contain.

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 ......

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...

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

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,...

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?