Over 1 million tech questions and answers.

Excel97 external references

Q: Excel97 external references

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.

Preferred Solution: Excel97 external 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: 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...



Read other 1 answers
Q: Excel97

I had a problem with 2 bad clusters on my C: drive. Scandisk ficed it but now Excel program or files will not load. I have reloaded Office 97 Excel and deleted any *.tmp,~*.* files. When reloading I get a message it cannot access an INI file. Thanks for any help.


We need to know what ini file that would be.

Read other 2 answers

When building a new custom Excel97 add-in, is there a way that I can hide the code? I have the VBA project password protected, but I would rather just prevent the project from appearing in the VBE's project explorer.

So how do I hide a VBA project within the VBE?


A:Excel97 - Add-Ins

I hate seeing a question sit this long. Try my Excel VBA site links:


Read other 2 answers

It said "The application requires the Windows installer to run" upon loading. I've try reloading the Office97 pro, and still did not work.

Help, thanks...

Read other answers

I have excel97 SR2 installed in my PC, what happen right now is that everytime i'm in the print preview, when i try to enlarge the file, the following error occur:

EXCEL caused an invalid page fault in
module EXCEL.EXE at 016f:3005cba6.
EAX=016f2edc CS=016f EIP=3005cba6 EFLGS=00010216
EBX=00000027 SS=0177 ESP=0062ece0 EBP=0062ed24
ECX=016f2ed0 DS=0177 ESI=00000000 FS=4317
EDX=00000ffc ES=0177 EDI=00000000 GS=0000
Bytes at CS:EIP:
8b 7e 54 85 ff 0f 85 ab 8b 0f 00 5f 5e c9 c2 04
Stack dump:
00000000 016f2edc 000000ff 0000030e 000001ea 0000031d 000001fa 00000000 00000000 0000031c 000001f9 0000030d ffffffff 0000031d 000001eb ffffffff

what does that mean, can nayone help. Thanks

A:excel97 error

Read other 12 answers


i got a question, i have excel 97 sr2, i have a worksheet and one of the column have about 10 repeating categories. my question is how to create a dropdown list like in access? is it possible only in excel?


p/s am i confusing you dreamboat?

[This message has been edited by kokaik (edited 08-07-2000).]

A:dropdown list for excel97

Read other 6 answers

Does anybody have sollution for following problem?

I have excel97 and window XP installed. When I use =today() function on worksheet, it shows "today" correcty. But when I try to open saved worksheet, excel gives following warning:

" File.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen File.xls?
Yes No "

In windows98 same excelsheet worked. Also if I don't use =today()-function no problem.


A:excel97, =today() and windows XP

Read other 6 answers

I can't find anything in Excel97 help that tells me how to add a bookmark to a cell in a spreadsheet (or even if it is possible). I want to be able to create a link to that cell in a Word97 doc. I've tried adding a name to the cell, but I can't get the link to go to that cell. Can anyone help?

A:Adding a bookmark in Excel97

I take it you can get it to link to the excel worksheet but you want to get it to link to a specific cell? Is that what you are trying to do?

Read other 3 answers

Dear guys

I try to be real smart, created a standard form for the company mileage reimbursement. Knowing people will change the formula and other fixed contents in it, i protected the sheet with a password.

Right now, I wish to change some of the content, I forgot the password. Can't get the sheet to be unprotected!

try to change the file name but to no avail.

Pls enlighten me.

A:excel97 protected sheet

Read other 11 answers

Hi -
I am having problems with VLOOKUPs when I try to lookup data which comes out of SAP downloads. Excel doesnt seem to recognize the data in the fields until you double click into the cell to activate it. The VLOOKUP will then work. But when you have a data list of 10,000 rows this isn't very practical! Does anyone know a way of either fixing the downloaded data or writing a macro which will automatically double click all the way down or is there another sort of VLOOKUP I need to use...

Thanks for your help....

A:VLOOKUP issue in MS Excel97

Read other 12 answers

Problem Summary:
I have a list of Names in column A, & the Number of Hours Training that each person has completed in column B. I want to summarise this data, so I know the % no. of people whose no. of training hours lies between 2 values.

Problem detail:
I want separate columns with headings as follows:

% no. of people doing 0 to 8 hours;
% no. of people doing 9 to 16 hours;
% no. of people doing 17 to 24 hours;
% no. of people doing 25 to 32 hours;
% no. of people doing 33 to 40 hours

Note that each person's name is recorded once only.

What formulas are required to show a count (or better still a %) of records between given values?

Any tips much appreciated!


A:Summarise no. records between 1 value & another:Excel97

Hi, Jen.

I've attached a sample file with all the formulas you need.

It is called jennie.txt.
Save it to your hard drive.
Right-click and rename it to jennie.xls.
THEN open it.

Hope it helps!

You'll note that some of the formulas have {} the curly brackets on them. When you type these formulas, instead of hitting Enter as usual, you will hit Ctrl+Shift+Enter. This makes them an Array formula, and puts the curly brackets on it. You do NOT type the curly brackets.

Read other 3 answers

In EXCEL97, how to you break a link to another spreadsheet...or can you?


A:Breaking an EXCEL97 Link

Read other 6 answers

why is my function not working?

Function Hubert(alpha As Double, m As Integer, sigma As Double, year As Integer)
Hubert = alpha / (2 * Pi) ^ 2 * Exp(-(((year - m) / sigma) ^ 2) / 2)
End Function

it is written in the VBA-editor of excel, I executed the compile-function and i saved.
nxt image is what excel gives when i try to use the function:

A:function (VBA excel97) not working

Read other 8 answers

When linking a cell from one workbook to another in Excel, they only seem to update if they are actually opened as different windows within the same session of Excel. I have tried updating via the Edit -> Link -> Update Now option, but this still doesn't alter the values. This is also a problem when I have various workbooks open in Binder.
Any suggestions?


A:Updating links in Excel97

Read other 6 answers

When I try to open an Excel97 shortcut (pointing to a file in a shared dir.)attached to mail it opens excel and returns a can not find file error. But when I manualy go to the shared folder and open the file in excel it works fine. Can anyone help!

A:{SOLVED} ATT: Excel97 Masters

See this post: http://www.helponthe.net/tsgbb/Forum11/HTML/000694.html answered by the very competent Dreamboat!!!

Read other 3 answers


so I have a file that I password protected the Macros of, and now I totally forgot the password (as in for the life of me I couldn't remember it).

Any one have any ways to recover the password?

A:Recovering Excel97 Passworded Macros

BUMP anyone?

Read other 3 answers

I'm runnung Excel 97 SR2

Only happened now, when I open this particular file it opened twice ie

details, the 1st was b4 any changes & the 2nd file was with changes.
any advise... could it be a virus?


A:{RESOLVED} excel97 file open twice


I closed one of the file (ie file.xls:1) Press saved and SOLVED.

How does it happened in the first place?
Anyone ever encounter the same problem?


Read other 2 answers

I cannot close excel97 using the close button it is a minor inconvenience, but none the less there has to be a reason why. On MS support.com the solution says that it is locked in edit mode, and all you have to do is hit Esc. This does nothing, any ideas would be greatly appreciated.

A:Close button not active? Excel97 SR2

Hi Voss.

Just do the Excel troubleshooting at:


Read other 3 answers

A friend has a problem with Excel97 AND 2000 instegating a tight loop that steals about a second of processor cycles every three seconds or so. This loop is tight enough that at load up of Excel you can hear the hard drive access being interrupted for that period and amount of time. The mouse is non-responsive also durring program load and after when just looking at a blank sheet. (same 1 second of three period)

This seems to have begun following installation problems with Eudora email that had DLL problems. He has since removed Eudora and has been using Exchange.

He has removed and re-installed both the 97 and 2000 Excel ( in fact all of Office 2000) but the problem persists.

I am at a loss as to advice for him. We have looked at the Running programs list when viewed from the Excell Help-System area but nothing pops out.

No other program seems troubled by this symptom.


A:Excel97 has tight system loop

Reinstall does not fix registry. Only uninstall, use Eraser, then reinstall does. Or this registry fix:

Start-Run and type


and hit enter. Browse to:


Right click Excel folder and rename to OldExcel, hit enter.
Exit registry editor.

Find folder called XLSTART and make sure no files are in there. Move them--at least temporarily.
Open Excel.
Then Tools-Options-General tab. Make sure nothing is shown in "alternate startup location" box. If so, remove it, close Excel and reopen.

Any help?
Make sure Outlook is not journaling Excel activities.


Read other 2 answers


whenever i share my excel file, other user will either overwrite my existing formula in a particular cell or manually put in the numbers.

is there a way to lock the particular cell so that there cells would not be changed?

i know that i can saved my file as read only if the files are shared but some of the files which i need other user to update info for me if you know what i mean. therefore, these would not work.

Thanks Dreamboat

[This message has been edited by kokaik (edited 08-09-2000).]

A:{Solved} Lock Cells for Excel97 SR2

Actually kokaik, I'd like to try my hand on this one.

Open the page you are working with, and select the cells you want people to be able to insert info. All cells on a spreadsheet are set to lock by default. Right click on the cells, select Format, and choose the Protection Tab. Uncheck the Lock. When you have made all the changes you want, then you go to Tools, Protection, Protect sheet or workbook, or protect and share. Whenever anyone tries to change a Locked cell, they will get an error message. It is a simple matter to unlock it, by going to tools, protection, unlock.

You can set a password to the Lock, or leave it blank, whichever you like.

Another handy function that occurs with this, is that if you hit the Tab key, it will tab to the unlocked cells, bypassing the locked ones.

Hope this helps, even if I haven't a "Dreamy" nom de guerre!

[This message has been edited by RandyG (edited 08-09-2000).]

Read other 2 answers

Wht criteria do I need to have to get the Subtotal feature to enable on the Data menu? I've tried it w/multiple cells highlighted and w/the focus on only one cell.

Help! Please!!!!!

A:Data > Subtotal in Excel97 not enbled on menu

Read other 7 answers

I am using excel97 and while creating macros, it usually displays the button on the screen to stop recording and have a relative reference option available. I closed this button once and now don't know how to get it back. I know to stop recording, I can go back under tools menu, but how do I get the button back or another way to switch from absolute to relative references while creating macros?

A:Excel97 macro relative reference button

I believe you already paid for a correct answer at EE. Keep in mind, in addition to what Bill said, that you will need to be in the macro recording mode to go to View-Toolbars and select the Stop Recording toolbar.

Brainbench MVP for Microsoft Word

Read other 2 answers

after experimenting with a few macros for the first time yesterday
now when I start recording a new macro the toolbar does not appear - have to stop recording via the tools menu, but cannot change between relative and absolute cell reference - as a novice
macro man this would be a help.
Steve C

A:excel97 - lost my stop recording toolbar

Right click in the toolbar area at the top of the window (i.e. next to your Standard and Foramtting toolbars.
A list of available toolbars are shown. If you are currently recording a macro, one of these is "Stop Recording". Click to check it and it should reappear.


Read other 2 answers

Could someone please jog my memory as to how to force text to start on a new line within a cell (not word wrap). If I wanted to type ABC in a cell then underneath that in the same cell type ABC again what keys get the cursor to the "second line" in the cell - like Enter would in Word.


A:[Resolved] Excel97 starting new line of typing in a cell

Okay, I got it. It's Alt Enter!

Read other 1 answers

For my robotic project I'm going to buy SUB-20
And use ROS
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

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

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

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.


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?

Read other 4 answers

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

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?

A:Solved: Excel References

Read other 13 answers

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

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.



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

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.


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


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?


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

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

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

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

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

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

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


Cross reference in Word doc has gone completely mad.
This seems to be the problem:

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

Read other answers

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"



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


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


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



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



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


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


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


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


<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

Read other 0 answers

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

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.


Go to Solution.

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

Is this what you are looking for?  The psref?

Read other 5 answers

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]


[HKEY_USERS\S-1-5-21-1397865392-4000231507-2547351323-1006\Software\Microsoft\Windows NT\CurrentVersion\Windows]

[HKEY_USERS\S-1-5-18\Software\Microsoft\Windows NT\CurrentVersion\Windows]

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

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\servic... Read more

Read other answers