Search results for query: *

Hi I was wondering if any one can help me. I have a spreadsheet which has links to another spreadsheet, they are a simple = the value of the cell in the other spreadsheet. I can open the spreadsheet okay on my machine. When I send it to my colleagues it opens with the message do you want to...

Hi I am using Outlook 2003. I am having trouble when I put an appointment in my calendar and send it to other people via the internet. If I type a persons e-mail address it arrives to them as appointment, however I select the persons e-mail address from my contacts it arrives as an e-mail...

Hi Can anyone help me. I have created some formulas in Excel which need to be on approx 9,000 rows. Someone told me if i named the formulas the spreadsheet would be smaller and work faster. I have the original formula on the top row and then copied it to the paste board, gone to the insert...

Hi I am a very experience user of access (but learning). I have a table of information and would like to create a new field in the table which combines 2 other fields. I want to do this in the table and not as a query. Can this be done and how do I do it Thanks Paul PS I am using access 2002

Hi I have word 2002, when I go to save a document the save as function is greyed out and I can not use it. This happened to me the other day and after re booting the maching it was okay. The problem has come back but afer re booting several times, I still can not use save as. Does anyone have...

I have a column of date with a date an order was created. I want to creat a new column which just shows the month and year that the order was created. Does anyone know how I can do this. For example order created 23/05/04 would like to see in new field as 05/2004 or 01/05/2004 I am sure...

I am using the sumif formulat in a speadsheet I am creating and wanted to know if there is a way in the sum range I can ask excel to conconcatenate certain columns to create my sum range. I realise I could create the conconatenate formula in another column and then point the sumif funtion to...

Hi I have a table of data which has formulas to calcute the restuls based on options which people select from a drop down box. Depending on what they select some of the rows may return blank figures. Is there anyway I can automatically tell excel to hide a row if a particular cell is equal is...

Hi Can anyone advise me how I can write a formula which makes a cell equal to a1 if the contents of another cell A1 in another sheet equals 1 and b2 if the contents of the same cell equals 2. I need to be able to drag the formula down so on the next row the formula then equals a3 or b3 etc...

Hi I recently upgraded to access 2002 from access 97 I am not an advanced user but slowly learning. I have 2 problems 1) In access 97 I had created some forms using pivot tables which used Excel to analyse the data. This was all automated and allowed me to create charts in excel...

I am have wrote a formula in an access query which works out the number of months between two date (approx) I want to round up the result and loose all the decimal places. I can not find the round function in access. Can anyone tell me what I have to do. Below is a copy of the formula...

Hi I am creating a line and column chart. Some of the data it has formatted as columns and I want it to be displayed as a lines. How can I change some of the columns to line and leave the others as columns. I am sure this is really easy, but I can not see how to do it Paul PS I am using...

Hi I am using excel 2000 If I try inserting a button from the control toolbox e.g. a combo box, list box, scroll bar, I get the error message cannot insert object. Does anyone know what the problem is. Thanks Paul

Hi If I try inserting a button from the control toolbox e.g. a combo box, list box, scroll bar, I get the error message cannot insert object. Does anyone know what the problem is. Thanks Paul

I am using Excel 2000. I have been sent a file which was created in excel 97. There is a sheet with button on which have macro's/drop down menu's assigned to them. I can not click these options. I can not even move the the box. Whilst I can see them, it is as though they are not there. Can...