NukedWhale

I installed Internet Explorer 7 a while ago. Nothing special, I prefer Firefox and when I need internet ecplorer I use IE Tab. Occasionally, I do prefer to use Internet Explorer directly. My problem is that when I open IE7, it will usually hijack my homepage and take me to the IE7 install page. I've already got the darn software and it keeps trying to get me to download it! Any ideas? Thanks, NW

Edit links requires me to change the source paths one link at a time. Anyway to change the source paths for multiple links at once?

Hello, I will try to explain my situation as best as I can. I have master word document A, which contains several links to cells in master excel document A. For a particular task I need to make a copy of master word document A and a copy of master excel document A. We'll call these new documents word B and excel B. What I need to do is make my Word B document change the source of all of it's links to Excel B, from master excel document A, so word B will update it's links from excel B. Is there any way to do this quickly and easily. Currently what I've been doing is copying word b and excel b to my usb key, having somebody else open it on their computer (so it can't find excel A, and switches to excel B), then saving the documents and copying them back to my computer. I'm hoping there is a better way. Thanks in advance. NW

Does it work? Thanks!

I assume that when you say "feature" you mean bug. I figured I could fix it with an if statement, it just adds time that I shouldn't have to spend. *Sigh* Thanks for responding.

The cell containing the Vlookup formula is formatted as general Here is the vlookup formula =VLOOKUP(TRIM($M$5),'Left out'!$C$5:$M$24,7,FALSE) The cell that vlookup is pulling in is formatted as general The cell that vlookup is pulling in is empty. I am using Excel 2003. Does this information help at all? Thanks for replying!

Here's my issue Cells in Worksheet A have vlookup formulas that look at a cell in Worksheet B and pull the cell contents in. My problem is that the cell my vlookup formula is looking at is empty, unfortunately it's pulling a value of zero, instead of pulling emptiness. To add another layer of confusion, it only does this occasionally.

Try it for yourself. Subtract 3.63 from 3.64 in excel. You should see a correctly displayed answer of .01; but if you increase the decimal places out far enough, you'll find a random number. So if you have any formulas tied to that number they can incorrectly evaluated because of it. Anybody know any workarounds or spreadsheets that do not have random floating numbers? The explanation why Excel does this is here: http://www.dailydoseofexcel.com/archives/2...nary-fractions/

Basically it's sounding like Total Commander, Xplorer, and perhaps Directory Opus are some of the best options. Are the free versions all pretty stable? I don't want to bring the wrath of the IT manager.

I think I'm looking for a different File Management System, as opposed to a desktop shell. Anybody have personal experience and recommendations?

Bah, there has to be alternatives available

Hello, I'm not a big fan of Windows Explorer, what good alternatives are available? Doesn't necessarily have to be free. Thanks

That was already done.

Hello, I'm having an issue with excel number formatting/auto correct. I'm not sure which one. I have a cell formatted as a number to two decimal places, but when I type in something like 3.50, it's automatically truncating it to 3.5. Is there anyway to disable this feature? I need it to always display 2 decimal places, even if that last decimal place is 0. Thanks

I'm having difficulty understanding your problem, but I'm a beginner. Perhaps you can better clarify it?

Any way to turn anti aliasing on for lines drawn by the excel and powerpoint charts apps?

This was helpful, thanks for posting

Is there any to control the alignment of row labels in charts? Excel/PP automatically defaults to center alignment which doesn't look very nice. I.E (my sample bar chart) row 1 label |===== row 2 label |==== row 4 label |== _______ I want to control the alignment of the row labels Thanks

When I look at the list of extensions on IE7, I see something called Research. What is it? Who put it there? Any reasons why I shouldn't disable it?

That's strange. In my experience I haven't had problems importing text into Word, exporting has created problems though.

Do you know where we can find this conditional sum add-on?

Countif tells me that I have four instances of a particular item. I want a formula or method to tell me the ordered "instance" of each one. So let's say I have 3 columns. Column 1 (Raw Data) A B A A Column 2 (The amount of times each letter appears) 3 1 3 3 Column 3 (My desired column which will tell me the ordered instance of each letter) 1 (First time A appears) 1 (First time B appears) 2 (Second time A appears) 3 (Third time A appears) How do I get my desired results for Column 3?

First convert your dates to numbers using =datevalue Then figure out the date values for the necessary date range Create a column C which will store the numbers to sum that are in the acceptable date range Then in column C create a formula along the lines of =if(minimum date value=<your date value=<maximum date value,the number to be summed,"") Drag and fill and then sum all the numbers in column C

I'm not very experienced with Macros, so I might be totally off-base... Why don't you set the Macro up to automatically create a copy of the document, automatically open it and then clear the colors from the new document.

Fixed.