• WSroberta



    Viewing 15 replies - 1 through 15 (of 103 total)
    • in reply to: cell names sorting with data (2003/2007) #1086738

      Thanks for your help – I am going to have to look at some sort of data referencing for them. Nearly scuppered the upgrade to 2007 this am as originally the dept thought this was a bug!!!

    • in reply to: Multiple Shows (2002/2003) #1068015

      Exactly what I was after – thanks

    • in reply to: excel charts (2003) #1041874

      Many thanks this has solved my problems – apologies for the delay in thanking you BT cancelled my broadband order on moving house and have only just got reconnected!!


    • in reply to: excel charts (2003) #1041208

      Unfortunately this gives me a data point for Quality and another for Customer Service. I am loooking for one data point which reflects both. If each range from 1 to 6 and I have a 1 for quality (x) and 6 for customer service (y) I would hope to find the data point in top left of the chart. If I have 6 for quality (x) and 1 for customer service (y) I would hope to find a data point in the bottom right of the chart.

      I think I am going to end up drawing something in powerpoint!!!

      Thanks anyway – Roberta

    • Thanks for your help – deleting and recreating sorted it

    • Thanks this worked a treat!

    • in reply to: change passwords (xp/2003) #1014332

      I have now moved all the files to one folder (there are about 500 – which is why I really don’t want to have to open them individually). I know how to write a macro to open a particular file. I can also write a macro to change a password, but I do not know how to automate the process to open them one after another.

      Help!!! Regards Roberta

    • in reply to: change passwords (xp/2003) #1013538

      Unfortunately, without opening each file, I cannot establish which have the password and which have not. Is is possible to open every file in a folder or sub folder and then reject those where the password is incorrect?

    • Thanks – easy whey you know how!!!!


    • in reply to: copying spreadsheets to new book (2003) #1003221

      Brilliant thanks.

    • in reply to: retaining custom security settings (xp home edition) #980007

      apoliogies think I should have placed this in internet explorer section – have copied to there.


    • in reply to: Word XP (Mail Merge) #960308

      I could not agree more. Another option – If you open the mail merge toolbar and select the toolbar options – (far right down pointing arrow head). and then select add or remove buttons, mail merge, you will note at the bottom that the ‘insert merge field’ is not selected. This is the one which was always available previously and is different to ‘insert merge fields’ which is on the toolbar.

      Select this one (which means you can click and select fields as you want them and put punctuation easily in between). I also deselect
      ‘insert an address box’, ‘insert a greeting line’, ‘insert Merge fields’

      I then arrange the toolbar so that the buttons are available as follows: ‘Main document set up’, ‘Open data source’, ‘Mail Merge receiptients’ (if I want to create a query), ‘insert merge field’, ‘insert word field’. This then pretty much puts the toolbar back to how it was originally, I then work from, left to right.

      Quickest way to rearrange toolbar is to hold down your Alt Key and then click and drag to new positions, or indeed drag off to remove.

      If you want to return it to how is was before rightclick toolbar area (or select tools menu), select customise, select toolbar tab, click mail merge toolbar and then selet reset (top right).

    • Many thanks – this has worked brilliantly. This has got me some brownie points ahead of my 3 month appraisal tomorrow!!

    • herewith cut down version.
      Just with tables
      query and report

      Thanks for your help

    • Opps – try this one –

    Viewing 15 replies - 1 through 15 (of 103 total)