Search:

Update: The 'Edit / Links' dialog box shows locked links as 'Locked' instead of Man or Auto.

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

We should have known this was coming ...

http://img244.imageshack.us/img244/710/wallstreetbull.jpg

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

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

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.

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