Search:

Type: Posts; User: Ruff_Hi; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Update: The 'Edit / Links' dialog box shows...

    Update: The 'Edit / Links' dialog box shows locked links as 'Locked' instead of Man or Auto.
  2. All links are already set to manual. I have...

    All links are already set to manual.

    I have never heard of locking fields - I just tried it and it seems to work very nicely. How do you tell that the fields are locked? I can imagine someone...
  3. Turn off Auto Update of linked info - Word 2010

    I have a word 2010 document that contains links to an excel 2010 spreadsheet. Every time I open the word document, it insists on opening the excel spreadsheet to update each and every link. The...
  4. Replies
    3
    Views
    2,620

    To answer my own question ... no. Combo Boxes...

    To answer my own question ... no. Combo Boxes (the excel name for Dropdowns) from 'form control' cannot be multi-select. List boxes can be but you need vba to get the selected items.

    An idea is...
  5. Replies
    3
    Views
    2,620

    True. When I set this up for a different...

    True. When I set this up for a different spreadsheet, I had it such that if you changed a 'higher' drop down, it reset (ie cleared) any 'lower' drop down using VBA.
    Interesting. I'll give this a...
  6. Replies
    3
    Views
    2,620

    Pivot Table Dynamic Filter

    Hi All. I am hoping that the masters on this forum can provide an answer to this question.

    I have a table that has a similar look to the following:


    Country State City
    England Kent ...
  7. Replies
    0
    Views
    2,045

    Summation Puzzle

    I have 200 vectors that I want to sum. Each vector has its own currency and there are 2 basic ways of looking at the vectors (sum by X, sum by Y, grand total).

    I want to add check sum so that I...
  8. Replies
    7
    Views
    8,323

    I was thinking about this more while I was...

    I was thinking about this more while I was walking my dog ... I have the tables in excel with range names ... I could set up a style (red, do not print) in word that held the corresponding excel...
  9. Replies
    7
    Views
    8,323

    I am using win XP - maybe that is one of the...

    I am using win XP - maybe that is one of the issues. The other thing is that my Word / Excel 2010 is still set up to use 2003 as the default format. I did try all combinations without much success....
  10. Replies
    7
    Views
    8,323

    I've been reading other posts in this forum and...

    I've been reading other posts in this forum and quite a few of them talk about macros. Re the above, I could see a macro solution being possible ...


    macro in excel to highlight range name and...
  11. Replies
    7
    Views
    8,323

    Excel tables in word (linked)

    I have some quarterly (and next year, monthly) reports that are fairly static (sections, words, types of tables, etc) while the actual numbers quoted in the body of the report and shown in the tables...
  12. Replies
    10
    Views
    17,191

    I do this all the time with dates, numbers, etc. ...

    I do this all the time with dates, numbers, etc. The way I do it is as follows:


    Have an excel cell that holds the value I want to put in the word doc
    Give that cell a range name
    copy the...
  13. Replies
    3
    Views
    1,498

    I think I will be running the sort process 3 to 5...

    I think I will be running the sort process 3 to 5 times (different sort keys) each quarter. I am certainly looking for a 'set and forget' approach that doesn't involved import, sort, export.
  14. Replies
    3
    Views
    1,498

    I have a large file (1m records, 300mb) that I...

    I have a large file (1m records, 300mb) that I want to sort based on multiple field values. Any one got any handy vba code that will do this for me?

    I've been googling for an answer and I think...
  15. Replies
    4
    Views
    1,796

    Yeah - sloppy testing on my behalf. Just found...

    Yeah - sloppy testing on my behalf. Just found out the above fix during a live demo ... sigh.
    correct - but good enough for what I am after as I am only interested in links in cells.

    Thanks for...
  16. Replies
    4
    Views
    1,796

    This is what I ended up using Public...

    This is what I ended up using


    Public Function isHaveLinkedCells() As Boolean
    Dim lCell As Variant
    Dim lCells As Range
    Dim lSheet As Object
    Dim lLinkTest As Integer

    ' remember the current...
  17. Replies
    4
    Views
    1,796

    Hi All! I'm looking for a way (in VBA) of...

    Hi All!

    I'm looking for a way (in VBA) of telling if an excel file has links to other spreadsheets. Basically, I want to put this into a vba function and then do something like ...



    if...
  18. Replies
    1
    Views
    463

    I have a pretty large deck (about 150 slides)...

    I have a pretty large deck (about 150 slides) that covers about 8 distinct topics. All of these slides makes swapping the topics around a little bit difficult. Is there a way to create a hirachical...
  19. Replies
    4
    Views
    1,598

    Well, it didn't get some of my numbers correct -...

    Well, it didn't get some of my numbers correct - but that was mainly because I got my maths wrong <hangs head in shame>
  20. Replies
    9
    Views
    882

    I typically leave it running for a few days and...

    I typically leave it running for a few days and then turn it off for 1 or 2. When the screen starts flickering, I take it out side and blow canned air through it - sometimes I get lots of dust out -...
  21. Replies
    1
    Views
    480

    We should have known this was coming ... ...

    We should have known this was coming ...

    http://img244.imageshack.us/img244/710/wallstreetbull.jpg
  22. Replies
    9
    Views
    882

    Thx guys. I use the canned air approach now -...

    Thx guys. I use the canned air approach now - but would prefer the dust not to get in there. This is my graphics card ...

    256MB nVidia GeForce 7900 GS (pic is not my actual card - just an image...
  23. Replies
    9
    Views
    882

    I have a dusty desk top. It is a dust magnet. I...

    I have a dusty desk top. It is a dust magnet. I also have a slightly dust attracting house (hardwood floors, 2 dogs, no grass in the back yard, etc). When my desktop gets dusty (on the inside), my...
  24. Replies
    2
    Views
    411

    Re: Windows Update - Review Available?

    thx Bob. I have acronis so imaging / back up is taken care of. I will be steering away from SP3 as I have seen reports that it hoses Media Center - like it did to me.
  25. Replies
    2
    Views
    411

    Windows Update - Review Available?

    My XP MCE computer was hosed by XP SP3 so I have had to rebuild it from scratch (reformat - reinstall). Since then, I have been ignoring the little 'updates available' icon thinking it was MS...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4