20 Most Recent Microsoft Office Excel 2003 for PC - Page 3 Questions & Answers

Make sure you have highlighted yhe area you want to change the color on then click on the color you want and it should change for the screen as well as the printing phase of the program.

I, too, am a veteran of DOS to Windows conversions, in fact, I make my living at it. But I learned over a decade ago to get over the differences, like using Tab instead of Enter to move around the screen, and of course, the cursor shape.

If you want your converted program to be accepted by people who have never seen DOS, you need it to follow Windows UI conventions.

The DSUM function is very useful, but it does use a lot of processing. Every DSUM function does a scan of every row of your table. There are a few ways you can reduce computing time.
First (and the most obvious) is to reduce the number of DSUM functions or reduce the size of your table. I presume you have already tried this.
Secondly consider using Pivot Tables to do the task, or to reduce the size of your table. There is a Pivot Table wizard under the Data menu. It's a fairly user friendly feature of Excel, so I suggest you try it out on your table. Pivot tables will be many times faster than DSUM functions because they only scan the table once. There are some tutorials available on the internet.
Third, if your DSUM functions are only summing one value in the table, then it would be much quicker if you can sort the table on the lookup value (or criteria). Then use LOOKUP, VLOOKUP or MATCH functions to find the value you're looking for. On a sorted table, these functions are many times faster that DSUM functions.
I hope this helps a little. It's hard to diagnose without seeing the spreadsheet and knowing the details of the problem you are trying to solve.

One way is to create a column next to the addresses then fill the new column with a sngle comma in each cell. Then merge the address and comma columns together to achieve the required result.

uninstall & reinstall the ms office

Make sure that you have all the updates for Microsoft office by visiting Mocrosofts website and download the hotfixes.

If that doesn't work

Try uninstalling office and reinstalling to fix the problem.

MAIL RECPEINT AS ATTECHMENT OPTION NOT VISIBLE IN MY OFFICE 2003 PROFESSIONAL

There is something not installed that it needs. If you have the Excel CD, try putting it in then running excel. If this is a corporate laptop/desktop try to connect to your company's network and running "advertised programs" in the control panel. If there was something related to Excel that hasn't been pushed to your computer, it would be pushed then.

Hope this helps,
Bill

What are the values of cells C4 and C5? Should the function above be "...RANDBETWEEN(A$4,A$5)" ?

BAHTTEXT(number)

The above function will convert a number to text. If you are referring to "figure" as a number than this should work for you.

You may want to try the TEXT(value,format_text) fucntion too but you'll need to supply a number format.

This could happen if your workbook is being shared.
1. Make a backup copy of your workbook (Excel file).
2. Open it in Excel
3. Check under Tools > Share Workbook and see if the "Allow changes by more than one user..." option is selected. If so, try unchecking it and save the workbook
4. Check the file size under File > Properties > General tab


Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing Ctrl+End and see where the end of your document is. If it is way beyond your current work area, select those extra columns and rows and go to Edit > Clear > All (Note: This will delete everything on those cells)

There may be compatibility problems. Do a repair using add/remove programs. There may be problems with COM components also. Right click on my computer icon and go to manage. From there go to Event viewer snap-in. There are logs for office softwares. Examine that. If there is an error it will be listed there.
:)
If this is helpful to you, please rate. Thank You!!!

You need XL viewer OR any software which can edit excel files. Search on google for the same.

Hi there.
You can download excel viewer directly from Microsoft here >>>>>>


http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0&displaylang=EN


Thanks for choosing FixYa!!

You can link to the original sheet or copy and paste - Linking might be easier as you only have 10. - Can you not use worksheets rather than excel. If you want to make it more autonomous you can index or look up the first sheet so any changes you make will be reflected back in your employee sheets.

There are a couple of types of spreadsheet - Depending on the size of the data you are working with - filter may the quickest option or Query report.

Your worksheet will contain all your data i.e. Customer, contact no, outstaning actions and due date - You can create a filter aon this set criteria on the due data - as less than or equal to todays date - which will only display your outstanding actions required by today or earlier.

Another option if you have installed MS Query, is to create a seperate report - again using the criteria of due date being less than or equal to today.

Producing this from your existing data is much easier than trying to re-create your data - But I can send you how I would create this sheet if the above explanation is not easy to follow - If you let me have your email address.

Hey. I tried pasting this information here for you, but it was too much..

Here is the link....

http://office.microsoft.com/en-us/help/HP012163661033.aspx

Search around on that site as well for what you need to do if that link does not help...

The value of C7cannot be found in the range - Hence the error.

Yes, it is possible to synchronise a file/ folder from your phone to laptop - Once you have connected them both - in My computer, select Tools/ Synchornise/ Set up and you should be able to work through the process.

maybe you should try to reinstall it