Over 1 million tech questions and answers.

Solved: Excel References

Q: Solved: Excel References

Is there a way to have Excel References "stay" on a PC? For example, I have a master workbook with millions of references installed (not really, but you know what I mean). I want to call a macro from that master workbook, but it will not work because that macro needs specific references installed to run. I do not want to have to install references on over 2k workbooks, just so I can use a macro?! What other options do I have?

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel References

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel References

Read other 13 answers
RELEVANCY SCORE 62.4

I am trying to create a field that is comprised of other fields. For example:

I want my A1 column text to be information from column B1, C1, and D1. So a formula would look like =A1-B1-D1 but obviously this will subtract tbe three cells from each other. I want it to look like Dog-Cat-Fish.

I hope I am explaining this well enough. I appreciate any help offered. Im not even sure if this is possible in excel though.

-Steve

A:Excel References

Text does not work in the same way as numeric data, which seems to be what you want to accomplish; do I understand that you want words to subtract from themselves, or do you simply want to place (in your example) three words each from a different column, separated by a dash, in another column?
Cheers,
John

Read other 4 answers
RELEVANCY SCORE 59.6

For some reason I can't find a thread addressing this simple problem?

I want Excel to auto update cell references after sorting, how hard can that be?

I got the following
A1 = Zack
A2 = Amanda
A3 = Sunny
A4 = Sara

What I want to do
B1 = Sunny 'regardless where the name Sunny will be after sorting column A
If I use B1 = A3 the cell reference does not update when I sort column A, I want it to update accordingly.

Please help!
 

A:Excel 2007 Auto update references after sorting

Let me see if I understand you:

A1 through A4 are cells and each cell has its'named range?

so Cell A1 is named ZACK, A2 is named "AMANDA" etc.?

The problem that not the contents of the cell are named ZACK but the rerefemnce to cell A1, and of course this does not change when you sort since you will always want to access A1 with the named referred to it.

I think this should have to be done with some VBA code, if it's only one cell it may be quite simple.

You would have to write a sorting macro that does several things:

1. read the value from each cell and the name given to that cell in a 2 dimensional array
2. sort the cells
3. run though the array, searching for the correspondign value and (re)-name that cell witth the corresponding name.

This is the way I think I would approach it.
However, there is one hitch: if two cell contents are identical, they get a name anyway, but, and here I go again, an extra step should be added in between 1 and 2

1. gather information
2. remove the reference for the named ranges
3. sort
4. create the new cell reference names again based upon the array in step 1.

Fun huh?
 

Read other 3 answers
RELEVANCY SCORE 51.2

In Excel using Office 2007;

Is it possible to change a cell reference inside a formula so that a formula itself decides which cells are selected?

E.G.

Formula 1

=IF(A1="Good","Good","Bad")

Formula 2

Somehow goes into Formula 1 and can change the A1 reference to something else, such as A2?
 

A:Solved: Editing Cell references

Read other 16 answers
RELEVANCY SCORE 50

Today, for the first time, I began to receive unresponsive script error messages relating to Google Chrome. Having never installed the program on my computer, I did a search and found 43 separate entries, several of which referred to my firefox program settings and chrome manifest file programs(whatever those are). Some of the files are tied into Microsoft Net Framework 3.5 while others have Java references. There is no reference to Chrome in my Program files nor in my uninstall devices.

How did these files get on my computer? What should I do about them? Help, please. Thanks.
 

A:Solved: Safely removing references to Google Chrome

are you sure it's google chrome? there are many files within xp or the os etc that are labled chrome etc for various functions. you need to be more specific about the error message. take a screen shot next time it pops up
 

Read other 3 answers
RELEVANCY SCORE 49.6

Dear Forum,
I am working on a long document in Word 2007 at the moment (high-performance laptop, Vista Home Premium SP1). Among other things, I am using charts, copied from Excel into table cells to keep them in place, within the document. These Charts have captions (Figure 1, etc.) and within the text I am referring to these figures with the help of cross references. This works fine until I try and print these pages. I have tried printing to a printer and printing to PDF file format and in both instances the documents gets screwed up. I have attached a pdf file with an example. As far as I can see, what happens is that the chart that the cross reference refers to, pops up itself where the cross reference is embedded. This not only occurs on the output, i.e. printout or pdf file, but appears after the print command in the document itself.

I would be very greatful if anyone had some advice on how to fix this.
Kind regards,
y_serenity
 

A:Solved: Word 2007: Problem with cross-references in text

It looks as if the cross-references are acting as hyperlinks to the part referenced, rather than a straight reference.

Have you got "insert as hyperlink" checked?
 

Read other 2 answers
RELEVANCY SCORE 45.2

I have a machine where the customer was trying to restore a user account to point to an "old" user area (my documents, application data etc etc), where XP had created a "new" user area that had the username with the "computer name" appended to the end of it.

He says he went to the registry and changed all of the entries that had "computer name" in them, and blanked the ones where all that was there was "computer name" (this is how he explained it to me). So basically it would seem that there is no "computer name" references in the registry any more. Of course, I don't think he made a backup <sigh>

Now, the computer won't boot and he wants me to fix it...it gets to the blue screen "Windows is starting up..." and the hard drive stops and the machine is hung.

Is this a fixable problem for anyone here?
 

A:Solved: regedit blunder...deleted "computer name" references

Read other 7 answers
RELEVANCY SCORE 42

I currently have gtx 260 x2 sli bridged, I was wondering if there is any freeware out there that will let me do more with the video cards than nvidia control panel, like control fan speeds or even just a monitoring tool.

A:Just need some references please

Have a look at Rivatuner it works well for me, have had a lot of success with it.

Read other 2 answers
RELEVANCY SCORE 42

Hi,
For my robotic project I'm going to buy SUB-20
http://www.xdimax.com/sub20/sub20.html
And use ROS
http://www.xdimax.net/forum/viewtopic.php?f=3&t=469
I'm looking for anyone familiar with
SUB-20 Multi Interface USB Adapter USB-I2C, USB-SPI, USB-GPIO, RS232, RS485, MDIO, Ir, LCD, PWM Click to expand...
 

Read other answers
RELEVANCY SCORE 41.6

I am using Firefox 6 with Windows 7, and periodically I find that, when I open, say, my bank information, my membership reference, etc., has not been saved, causing me to have to input it all again. I do tick the "Remember these details?" box, but perhaps two days later all the info has gone again. It is more of a nuisance than a desperate situation, but I would like to find out how I can prevent this from happening, if anyone has any ideas. Many thanks.
 

A:References not being saved

Read other 6 answers
RELEVANCY SCORE 41.6

Anyone got any suggestions? I have a pretty thorough knowledge of windows 7 and am looking to get the greatest collection of knowledge possible. I already have been through the windows 7 inside and out deluxe, and been though google more than I would like to admit, anyone got any good references for pretty much anything advanced windows 7? Modding, administrating, security & configuration, etc?

A:Best Windows 7 References?

For the best information available on the net or off
Tutorials - Windows 7 Forums

Read other 7 answers
RELEVANCY SCORE 41.2

Hello,
I've checked all the /dev/tty* references under Linux (bash) but none work for COM* access (via Python in my case). I've enumerated all available tty references using a simple python script but still unable to "decipher" the right string for the
serial access. The equivalent Python code runs under Debian Jessie without any issues (of course, the COMx reference there is slightly different). Please let me know how to access COM ports using bash in Linux for Windows (build 14965). Thanks.

Read other answers
RELEVANCY SCORE 41.2

I am currently trying to make an IF statement in Word 2003 that will be conditional on (and auto-fill with) information in 2 different Text Form Fields.

The two fields are bookmarked as "Own1" and "Own2"

I would like it to simply display the input information in the "Own1" field if "Own2" contains no data, but display "Own1 and Own2" if Own2 does contain data.

Just to be very clear, here are the two different examples.
Ex. 1 - Own1 = John Smith ; Own2 is empty

Print - John Smith

Ex.2 - Own1 = John Smith ; Own2 = Jane Smith

Print John Smith and Jane Smith
{IF { FORMTEXT Own2 } <> "" "{ FORMTEXT Own1 } and { FORMTEXT Own2}" "{ FORMTEXT Own1 }" \* CHARFORMAT }

I currently have this as the IF statement and it doesn't work as I want. All it will display is "FORMTEXT" (I have tried this with REF in place of FORMTEXT and I get the same result), unconditional of any text being present in the "Own2" field. It seems as though the IF statement never gets to the comparison part of the IF statement.

Thanks for any help!
 

Read other answers
RELEVANCY SCORE 41.2

Hello Everyone,

I am utilizing McAfee as my protection of choice and I used to use xofsoftse spyware remover. I was thinking of trying a new spyware remover before I renewed xofsoftse. As part of Comcast internet toolbar it has a free spyware removal tool but I have always heard of utilizing multiple spyware software. Since there are way to many bad ones out there I wanted to hear if anyone has anything great to say about a particular program. Free is always better but a great working program is what im after. In past spyware removers I would scan and get things with one scanner that another would not find and then it would find them again right after deleting the spyware?

I have a 4year (1year hard drive) old dell inspiron 8600, Windows xp sp2, 90gb, (only half full) ,1.7 mhz processor, 512 ram. I generally communicate and photo edit with my computer with some video editing in there also.

Thanks

jeff
 

A:spyware remover references

I think AVG Anti-Spyware and SuperAntiSpyware Are Good Choices,
AVG also scans for trojans as well as spyware,
and alot of people recommend superantispyware,
both superantispyware and avg anti-spyware have paid and free versions I only have the free versions on both,
the avg anti-spyware starts as a paid version but after 30 days it reverts to the free version.
.....................................|
(links are in my signature.) \/
 

Read other 2 answers
RELEVANCY SCORE 41.2

I have an 18 page manuscript that I need to create a reference table at the end. I know word has an index feature and I have gotten as far as marking the text but I need for one to number the references. Does anyone know how? I dont want to have to copy and paste each reference and number them manually.

TIA
 

A:Word 97, using index and references

The PDF files, Using Word for your Dissertation and Using Headers and Sections here should help.
 

Read other 1 answers
RELEVANCY SCORE 41.2

Hi,

I have an autonumbered document with autonumbered figure captions as well. In the text of the document I have cross-references that are linked to Figures and other numbered sections of the document. To update the cross-referenced field, I right click on the reference and select "update field". Is there a way to update all of the fields at once (similar to updating the table of contents) instead of doing one at a time?

Thanks!
 

A:Updating Cross-References

Oh my goodness, yes.
Unless you have it turned off, fields should update just by doing a print preview (check tools-options, print tab), or by hitting Ctrl+A and then F9.
 

Read other 3 answers
RELEVANCY SCORE 41.2

I'm writing my dissertation. I am using cross-references for both Tables and Figures (Word 2003). I'm also using EndNote for my references (I have no idea if this has anything to do with the problem).

The problem is that EVERYTIME I print, it does something weird and puts in a large amount of white space before a cross-reference. On average, 3/4 of a page of white space. If I click to the right of the last word before the reference, it highlights all the space as well as the cross-reference for deletion. If I put the cursor right before the cross-reference, I can just back space and delete it all. I delete it all the way back to the word before the cross-reference and add the proper spacing, save and print, it still does the same thing.

Any help would be greatly appreciated.
 

A:MS Word and Cross-References

Read other 7 answers
RELEVANCY SCORE 41.2

I have an Excel97 spreadsheet that refers to, and summarises, a number of other spreadsheets. The files are all within sub-directories of one single directory held on a NetWare5 file server. I want to be able to copy this complete directory structure to a CD and then onto a laptop to enable it to be updated elsewhere, and then copy it back to the network. The top level directory names are the same on the file server and the laptop.

The problem is that when I copy the files to CD, the formulae all appear in the form:

='\\Sample_nds\.SAMPLE_DATA.sampleltd\StockLists\GROUP 1\[Region 1.xls]Store Summary'!$A$300

with the full NetWare directory handle which is not recognisable on the laptop.

Is there any way of doing this, to allow the files to maintain their linkages when moving them between machines? Any help would be greatly appreciated.
 

A:Excel97 external references

Evening Steve,

Have you tried clicking on Tools | Options | View and then making sure that the Formulas option in the Windows Options section is Unchecked? That should sort it out once you've finished transferring the pages, although why it would want to check itself just when copying to CD is something I'd have to work on...

Cheers

Liam
 

Read other 1 answers
RELEVANCY SCORE 41.2

Hi,
I would like to know if I can delete all orphaned file/path references,shared DLLs,help file references,application path and activeX control references detected by my disk cleaning tool.Will it cause any harm to my PC after deletion?Thank you for your advice.
 

A:Orphaned File References???

I would not simply delete them, but move them to a hold folder. And then use the PC for a few weeks to see if any of them were really needed.
 

Read other 1 answers
RELEVANCY SCORE 41.2

Is there a way to check or uncheck references using code in Access?

I have a database that will be opened by Access 2003 or 2007. Both versions will need to be able to use the Access Reference "Microsoft Outlook 11.0 Object Library" or "Microsoft Outlook 12.0 Object Library".
 

A:Access Database - References

Read other 6 answers
RELEVANCY SCORE 41.2

I was wondering if it was possible to remove the libraries drop down in Explorer, as it is just a waste of space for me. Network too infact. I only use Favorites and Computer. Also, I would like to change the buttons in the start menu(Documents, Pictures, Music, Videos) to point at the folders themselves, instead of the libraries, is this possible? If so, how would I do that? Thanks!

A:Removing References to Libraries

Hello YouTellMe

Is this what your looking for - Libraries Folder - Add or Remove from Navigation Pane

Regards Danny

Read other 3 answers
RELEVANCY SCORE 40.8

My problem is similar to BTHORNBURY (All Search Engines Hijacked). His/her question hasn't been answered yet, and it seems we should not be using the recommendations made to other users, so . . .

I pretty much always use Google to search for things. It throws up a list of links to click on, but about three days ago, whenever I click on a link, I get sent to another search engine, like INFO.COM, or to another site. For example, I click on

Detachable Two-Piece Bamboo Knife Block shopping in Crate and ...Shop for Detachable Two-Piece Bamboo Knife Block Knife Storage and other items in the Cutlery department at crateandbarrel.com.
www.crateandbarrel.com/family.aspx?c=608&f=26236 - 79k - Cached - Similar pages
and I end up at a Smart&Final store website, which has nothing to do with what I was looking for. And my "back" button is usually disabled, so I cannot get back to the search page.

But then sometimes, I will click on the link and get sent to some other site (like I am looking for X-Files episodes and I get sent to a car dealer website), and when I get back to the search results, the links work OK.
Here is my HijackThis log:

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 9:06:16 PM, on 8/16/2008
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16705)
Boot mode: Normal
Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\csrss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\servic... Read more

Read other answers
RELEVANCY SCORE 40.8

I just cleaned some nasty viruses off my machine, but every time I boot up I get an error message telling me that it cannot find C:\windows\system32\ddayy.exe, and that I should remove references to it in the registry. I ran the registry search tool looking for ddayy.exe and got the following:

[HKEY_USERS\.DEFAULT\Software\Microsoft\Windows NT\CurrentVersion\Windows]
"load"="C:\\WINDOWS\\system32\\ddayy.exe"

[HKEY_USERS\S-1-5-21-1397865392-4000231507-2547351323-1006\Software\Microsoft\Windows\ShellNoRoam\MUICache]
"C:\\WINDOWS\\system32\\ddayy.exe"="ddayy"

[HKEY_USERS\S-1-5-21-1397865392-4000231507-2547351323-1006\Software\Microsoft\Windows NT\CurrentVersion\Windows]
"load"="C:\\WINDOWS\\system32\\ddayy.exe"

[HKEY_USERS\S-1-5-18\Software\Microsoft\Windows NT\CurrentVersion\Windows]
"load"="C:\\WINDOWS\\system32\\ddayy.exe"

How do I keep the computer from posting these messages every time I boot up? What is ddayy.exe anyway? Thank you for any help you can offer.

A:How to clean ddayy.exe references in registry?

Hi D. Scott and welcome to TSF !

Please follow the "HJT - 5 steps against malware" link in my sig. Read the instructions there carefully and post your final logs in a new thread in the HijackThis section. Our security analysts will review them and tell you what to do to get rid of these messages for good. Be patient as the HijackThis section is very busy and it may take several days before you get an answer.

Read other 1 answers
RELEVANCY SCORE 40.8

Hi,

Cross reference in Word doc has gone completely mad.
This seems to be the problem:
https://support.microsoft.com/en-au...heading-number-after-you-insert-a-new-heading

But I can't seem to be able to fix it.
Any idea whats up?
Thanks!
 

Read other answers
RELEVANCY SCORE 40.8

I am using word 2007 for an academic paper. I have a lot of examples that generally look like this:

(1) a. this is part one
b. I continue here
c. some more text here

When I add a cross-reference to the example, Word only allows me to choose the example number (1), but sometimes I would like to specify that I am talking about e.g. (1a). If I just add the letter in the middle of the reference, it disappears every time I update the field. Adding the letter outside of the reference, e.g. (1)a is not an acceptable option for many journals. Is there a way to make the letter stay inside the reference and not disappear after I update it?

Thank you!
 

Read other answers
RELEVANCY SCORE 40.8

Hey guys, 
 
I noticed that in my firefox browser it looks like the html is referencing chrome? Almost as if I'm actually in a firefox skinned version of chrome?  anyone know what this means??

<?xml version="1.0" encoding="UTF-8"?>

<!-- This Source Code Form is subject to the terms of the Mozilla Public

- License, v. 2.0. If a copy of the MPL was not distributed with this

- file, You can obtain one at http://mozilla.org/MPL/2.0/. -->

<!DOCTYPE html [

<!ENTITY % htmlDTD

PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"

"DTD/xhtml1-strict.dtd">

%htmlDTD;

<!ENTITY % globalDTD SYSTEM "chrome://global/locale/global.dtd">

%globalDTD;

<!ENTITY % aboutHomeDTD SYSTEM "chrome://browser/locale/aboutHome.dtd">

%aboutHomeDTD;

<!ENTITY % browserDTD SYSTEM "chrome://browser/locale/browser.dtd" >

%browserDTD;

]>

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>&abouthome.pageTitle;</title>

<link rel="icon" type="image/png" id="favicon"

href="chrome://branding/content/icon32.png"/>

<link rel="stylesheet" type="text/css" media="all"

href="chrome://browser/content/contentSearchUI.css"/>

<link rel="stylesheet" type="text/css" media="all" defer="defer"

href="chrome://browser/content/abouthome/aboutHome.css"/>

<script type="text/javascript;version=1.8"

src="chrome://browser/content/abouthome/aboutHome.js"/>

<script type="text/javascript;... Read more

A:Should my FireFox Browser contain references to chrome?

Hello and welcome:
 
That is not "Chrome-the-Google-browser". It is a different "Chrome", as explained here: https://developer.mozilla.org/en-US/docs/Glossary/Chrome
 
HTH,
 
MM

Read other 0 answers
RELEVANCY SCORE 40.8

Is there any reference site that gives explanations for the experimental settings in "opera://flags/"? I do not understand many of them, and need more information.

A:opera:flags (Experiments) references?

14 Opera Flags Tweaks for Better Browsing Experience - Hongkiat

Read other 6 answers
RELEVANCY SCORE 40.8

Good morning/afternoon to you all. First of, thanks a lot for letting me into the community. I hope we'll be able to exchange as often as possible. Well i'm a digital artist and i wanted to combine a professional laptop with some creative possibilities. So Yoga 260 seemed to be the best match (for its maneuvrability and integrated stylus)... to the point I saw the exact screen specifications... which are to be perfectly honest, pretty disappointing when it comes to refresh rate and Gamma/Adobe RGB range coverage. So i simply want to customize the hell of my future Yoga260 future acquisition, but I have 2 questions:Can any 12.5i multi-touch display do the trick, or must I get something compatible in any way.If I must get something compatible, which Full HD screen with better RGB ranges so i can do a better job ? Many thanks for any help you can provide me. All the Best max

A:References for screen replacement - Yoga 260

Well I found other screens there: http://www.ebay.co.uk/itm/like/182054053530?limghlpsr=true&hlpv=2&ops=true&viphx=1&hlpht=true&lpid=1... But i'm afraid it will be the same in some ways. And for me it's impossible to check on the technical specs of the screen about refresh rate and gamma range. Any idea is very welcomed

Read other 1 answers
RELEVANCY SCORE 40.8

I need to know how to manually RIP OUT every single reference of ie8 from the disk, the registry, and my life. i am trying to reinstall ie7 as a trouble shooting step because IE8 is completely messed up. i cannot downgrade normally because the uninstall entry is missing. spuninst.exe fails to function.

i will rip the head off of anyone who responds with a cut and paste microsoft document because i am so fed up with people beating around the bush and assuming that there is some sort of easy to do this that inevitably will fail just like the rest.

I want a list of registry entries and files to delete. i am treating IE8 like a virus and wish to remove it by hand as such

A:How to manually remove all references to IE8 so i can reinstall IE7

I need to know how to manually RIP OUT every single reference of ie8 from the disk, the registry, and my life. i am trying to reinstall ie7 as a trouble shooting step because IE8 is completely messed up. i cannot downgrade normally because the uninstall entry is missing. spuninst.exe fails to function. i will rip the head off of anyone who responds with a cut and paste microsoft document because i am so fed up with people beating around the bush and assuming that there is some sort of easy to do this that inevitably will fail just like the rest. I want a list of registry entries and files to delete. i am treating IE8 like a virus and wish to remove it by hand as suchi 2nd that move too i have had a lot of trouble with ie8 from the start -- a system clean up would help!!

Read other 5 answers
RELEVANCY SCORE 40.8

I want to change ALL references to E:\ to D:\ both in file names themselves & text within all file names on an entire drive. I know how to do this with the registry but not how to search & change a whole drive worth of files.

Anyone know how to do something like this? Any suggestions, warnings, tools that would accomplish this, etc... would be appreciated.

Thanks,
Jim

Read other answers
RELEVANCY SCORE 40.8

Is there any reference site that gives explanations for the experimental settings in "opera://flags/"? I do not understand many of them, and need more information.

Read other answers
RELEVANCY SCORE 40.8

Hello all, bought a  X1 Yoga gen3  with the following reference:  20LDCTO1WW.Saw a list with specs from LD, LE etc, but did not save it.Anyone? I offcourse know my own config but would be nice to see that list again. Thanks, and happy bargain hunting today.













Solved!

Go to Solution.

A:List X1 Yoga gen3 references. What is LD, LE etc?

Is this what you are looking for?  The psref?
 
http://psref.lenovo.com/Product/Think_Tablets_and_Convertibles/ThinkPad_X1_Yoga_3rd_Gen

Read other 5 answers
RELEVANCY SCORE 40.8

Hi,
I would like to know whether I can delete all orphaned file/path references,orphaned shared DLLs,orphaned help file references,orphaned ActiveX control and application path references detected by a disk cleaning tool.Will it affect my PC after deletion?Thank you for your advice.
 

Read other answers
RELEVANCY SCORE 40.8

Good morning/afternoon to you all. First of, thanks a lot for letting me into the community. I hope we'll be able to exchange as often as possible. Well i'm a digital artist and i wanted to combine a professional laptop with some creative possibilities. So Yoga 260 seemed to be the best match (for its maneuvrability and integrated stylus)... to the point I saw the exact screen specifications... which are to be perfectly honest, pretty disappointing when it comes to refresh rate and Gamma/Adobe RGB range coverage. So i simply want to customize the hell of my future Yoga260 future acquisition, but I have 2 questions:Can any 12.5i multi-touch display do the trick, or must I get something compatible in any way.If I must get something compatible, which Full HD screen with better RGB ranges so i can do a better job ? Many thanks for any help you can provide me. All the Best max

Read other answers
RELEVANCY SCORE 40.4

As many of you know there is suddenly a problem with opening the old word Documents in the CRT contracts directory. It takes a long time to open them. This is because they were all created in the old bas(CRM Tool), and there is a reference to the old avenue server which is now turned off.

If you remove this reference then the file will open normally. Unfortunately I know of no way to do this to all the files at once, you will have to do it file by file. Is there a way to get all the files fixed at one time? Please help!

Mike Varone
Training Manager
[email protected]
PH: 440-871-8900 ext. 320

Below Is a link to a file that will show you how to remove the reference, however this is per document.
http://dkrmed015/Admin/ServiceDesk/rame-avesql-dot-addin-reference.swf
 

Read other answers
RELEVANCY SCORE 40.4

Hi all,

I am always looking for my "cheat" sheets as I work at my desk. Currently, I print out the material and stash it somewhere along side my monitor or on the bookshelf. I even have a few taped down to my desktop and have to move my keyboard out of the way to see them. I thought that it would be so useful to have the ability to use all that empty space on my computers desktop as a platform to hold these images.

What I'd like to do is find a way for me to take one of my reference images and place it on the desktop, size, crop and place as I need and then lock it down to that position on the desktop. Then grab my next image and place it somewhere else on the desktop, size, crop, and place... then the next... and so on until I have 15 or so images as my wallpaper. All of them places real time around my icons and all immediately visible when I click the "show desktop" shortcut on the task bar. Would be nice to be able to quickly modify too!

Anyone know of a method or program that would help me out?

Respectfully,

Jon

A:Wanting to use technical references as Wallpaper. Many images

You could do that with Word though I wonder whether 15 would still be readable.

What you do is make a snip of each sheet and store it as a .png picture. Then you open a Word sheet in landscape mode and subdivide that with rectangular shape inserts. Then you store the snips into these rectangles. When you got all of them, make a .png snip of that word page and use it as a desktop background.

And if you do not have Word, use the free Libre Office Writer. It is a bit more finagle than Word, but it works.

Read other 2 answers
RELEVANCY SCORE 40.4

This is quick and dirty,

If you ever get hacked, you might not know it. Your Anti-Virus might miss the infection and the malicious process might run invisible to task manager.

One quick and dirty way to check for signs of infection is to create a log that contains all the URL's contained within the files and programs on your computer. Because almost all malware is going to try to send and receive files to and from your computer, making a log of every URL contained on your computer can reveal some really interesting information. For instance, you might discover that a PDF file you thought was inccocent , contains referrences to a known malware domain hosted in China or Russia.

To create your log, you will need:

Strings from Sys Internals: This tool will search through every file and folder on your computer (or just one if you prefer) and print out all the ASCII and Unicode text it finds contained within them. It is faster than FINDSTR in the command line, and its output is cleaner and more organized.

Please note that to use the script as is, you will need to place the strings executable in your system32 folder. OR, you will need to add the path of the strings.exe executable to your PATH environment variable.

Next, copy and paste the following command into a command prompt:


Code:
cls && cd \ && strings -q -s | find "http://" > "%USERPROFILE%\Desktop\Http_Log.txt" && notepad.exe "%USERPROFILE%\Desktop\Http_Log.txt&... Read more

A:Quick Tip: Log all references to HTTP in your files and programs.

Nice thread.
Looks like it took you awhile.

Read other 3 answers
RELEVANCY SCORE 40.4

Hello, When looking for a replacement to switch from a US to an Azerty BE backlit keyboard, 2 different references appear:- NBL KBD,BE,DFN - 01HW247- NBL KBD,BE,CHY - 01ER957 What's the right one or what's the difference? Thank you for helping. 













Solved!

Go to Solution.

A:Several references found for a P51 Azerty Belgian keyboard: which one is the right one?

Two different suppliers of the keyboard.  Darfon (I think) and Chicony.  There may be some differences in exact "feel" or other aspects, but the base functions should be the same.
 
Z.

Read other 1 answers
RELEVANCY SCORE 40.4

Three editors on my project have all experienced the problems listed below in several documents. We were all using Word 2007 with SP2, not SP3 (Iíve now installed SP3). I have found two other posts online with the same problems, but no responses.

The documents have Next Page section breaks between sections and appendices. Heading 1 is numbered 1, 2, 3; Heading 7 (the appendix heading) is numbered A, B, C. We use the Figure label for captions in the document body and a custom label, apxFigure, for captions in the appendix.
1. When a caption is inserted in the appendix, all figure captions in the body (Figure 1-1, etc.) change to the appendix label (apxFigure) and the numbering changes to A-1, A-2, etc.
2. One or more captions do not appear on the cross-reference list despite numerous reinsertions of the table of figures (TOF).
3. One or more captions are not included in the table of figures list.
4. Sometimes, the TOF will display the caption, but it wonít be available in the cross-reference Ė and vice versa.
We have tried:
1. Replacing all captions (sometimes corrects the problem, sometimes not)
2. Copying and pasting the document section by section (without the last paragraph marker) into a new document, thinking it might be corrupted. No difference.
3. Updating all captions and cross-references, both individually and collectively.
Does anyone have an explanation -- better yet, a solution? Does the service pack have anything to do with this?

Tech Support Guy System Inf... Read more

Read other answers
RELEVANCY SCORE 40.4

Over time I delete lots of files and folders. I usually use the 'Control-Delete' trick to "permanently" delete the files. However my understanding is that although this method may remove the file reference from the Windows file catalog, they files still may exist on the hard drive. And appropriate tools can recover these lost files. For example, using Recuva, one can see lots of references to files that I had previously deleted using the 'Control-Delete' trick. I would like to delete all of these references. Is there a tool that can scan the system and delete all references to these deleted files? I tried using Ccleaner, but this tool does not delete these references (unless I am using it incorrectly?). Anything else?

A:Permanently delete references to deleted files?

CCleaner has this guide on how to do so, the first method detailing how to alter the settings so it does it automatically.The second method is just to wipe the data manually, so you can do it on a case by case basis.

Read other 5 answers
RELEVANCY SCORE 40

Hi All,

I have a brand new build that worked fine, stress testing and all, until the IT company for the business I built it for got it attached to the network and installed a bunch of printers, etc. (the computer is at a printing company). I went in shortly after they left and received a blue screen within a few minutes just by opening Firefox and trying to browse to a website. It blue screens even in Safe Mode. It always does it when I'm doing something with a program (i.e. trying to just open Calculator, or getting Firefox open and then BSOD after a random amount of time surfing the web, but within a few minutes). I was able to navigate around in Windows Explorer for a while and move the dump files to a flash drive so I could bring them home. I have 8 dump files but I'll only post the debug from the first and last for you.

System specs (everything stock speed/settings, except all Windows OS stuff is updated, no additional software or tweaked settings except what the IT company did):

Core i7 3770k
Hyper212 Plus CPU Cooler
Kingston HyperX 3k 120GB SSD
XFX Double D Black Edition Radeon 7770 GHz Edition
ASRock Z77 Extreme 4 Mobo
Rosewill HIVE Series 650W PSU
G.Skill Ripjaws X Series 16GB (2x8GB) DDR3 2133
Samsung SS-224BB SATA Optical Drive
Windows 7 Pro SP1 (Fully Updated)

First MiniDump Data:

Microsoft (R) Windows Debugger Version 6.2.9200.20512 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.
Loading Dump File [H:\Minidump\120712-12916-01.dmp]
Mini... Read more

A:BSOD win32k.sys debug references csrss.exe process

Welcome aboard.

Code:
*******************************************************************************
* *
* Bugcheck Analysis *
* *
*******************************************************************************

Use !analyze -v to get detailed debugging information.

BugCheck 50, {fffff900c1cb5000, 1, fffff960000c23b4, 0}
Could not read faulting driver name
Probably caused by : win32k.sys ( win32k!sfac_GetLongGlyphIDs+84 )

Followup: MachineOwner
---------
Your crash dumps are not showing any finite probable cause. In such a situation, it is better to enable Driver Verifier to monitor the drivers.

Driver Verifier - Enable and Disable

Run Driver Verifier for 24 hours or the occurrence of the next crash, whichever is earlier.

Let us know the results, with the subsequent crash dumps, if any, following the Blue Screen of Death (BSOD) Posting Instructions .

Read other 1 answers
RELEVANCY SCORE 40

Alright so I'm using the 2011 version of Live Mail and all has been well since install... But now an old problem I saw with the older version is rearing its ugly head again: the program will begin to load, but after a while i get the message that Live Mail can't open because of corrupted data in my calendar (don't remember the specific message or error code here at the office), and of course i've never used its calendar. Sometimes a reboot helps, others not at all.

From googling i see this is not a new problem, but I also don't see a definitive cause or solution. Has anyone else had success making this go away?

A:Live Mail won't open...references bad calendar data?

  
Quote: Originally Posted by papaSmurph


Alright so I'm using the 2011 version of Live Mail and all has been well since install... But now an old problem I saw with the older version is rearing its ugly head again: the program will begin to load, but after a while i get the message that Live Mail can't open because of corrupted data in my calendar (don't remember the specific message or error code here at the office), and of course i've never used its calendar. Sometimes a reboot helps, others not at all.

From googling i see this is not a new problem, but I also don't see a definitive cause or solution. Has anyone else had success making this go away?



Seems to be a corrupted registry entry. There are some suggestions here. Windows Live Mail Could Not Be Started. Calendar contains corrupt data. Error 0x80070057

Ken J

Read other 8 answers
RELEVANCY SCORE 40

I'm having some incredibly frustrating problems with the INCLUDETEXT command - here is what I want to accomplish.

CREDITS folder. This folder contaings about 15 SUBFOLDERS each with their own word document. All of these documents are to share the same 'Project Name,' 'Project Location,' etc.

I want to be able to enter the Project Location, Project Name, etc, once and have this update in all of the files. To do so I have created a seperate Project_Info.doc in the main CREDITS folder and have entered placeholder words and made them referencable, functioning bookmarks.

The folders look like this

T:\CREDITS\SUBFOLDER 1
SUBFOLDER 2
SUBFOLDER 3
...
SUBFOLDER 15
Project_Info.doc

The CREDITS folder is going to be copied and pasted into various project folders, updating the Project Name and Location each time (such as P:\CREDITS or P:\BUILDING\CREDITS)

When I use the following include text command

{INCLUDETEXT "\"T:\\LEED [Folder Structure]\\Credits+Submittal\\Project_Info.doc\""}
the entire file is included followed by a carriage return which I do not want. When I reference the fully functioning bookmark as follows:

{INCLUDETEXT "\"T:\\LEED [Folder Structure]\\Credits+Submittal\\Project_Info.doc\" ProjName"}

I get an "Error! Not a valid filename" message. Furthermore, if I reference with links from the server (say on the T:\ drive) when I copy and paste the folder into a new project on, say, the P:\... Read more

Read other answers
RELEVANCY SCORE 39.6

On xp+sp3 when using scripts to open a file on the active drive I use e.g. \Scripts\tester.ahk

which used to get F:\Scripts\tester.ahk in my case, but now I get this error message instead

---------------------------
Information
---------------------------
File "C:\Scripts\tester.ahk" not found
---------------------------
OK
---------------------------

I've installed several new apps recently, so am not sure if one of them changed xp, or if this is something I've done inadvertently. How do I reset it?

A:\filepath\filename no longer references active drive letter, gets C: instead

I'll do a little research into this, though admittedly I haven't toyed with scripts a lot. In the mean time, couldn't you just add F:\ to the start of the file path?

Read other 2 answers
RELEVANCY SCORE 39.6

Does anybody have an idea how to change the default font and text size for footnotes in word 2003. I can do it manually as in highlight and right click the text and set the font that i want. But as soon as i insert another footnote it reverts back to the original font setting and not the one that i previously specified.

Any ideas?

Edit: I should add that this is in an existing 80 page document.
 

Read other answers
RELEVANCY SCORE 39.6

I am working with a .docx file about 20MB. I included several figures (different formats, e.g. .eps, .emf, etc.) with numbered captions and crossreferences in the running text. However, Word screws up the document and puts an additional figure into the correct crossreference itself. I do a fair amout of editing, deleting the double figure, but when trying to print the document (update table, numbers, etc.) the double figures are back. For me it is still a mystery, since not every figure is put twice in .docx. Can anyone help me with that? Many thanks in advance!
 

Read other answers