MS Excel 2003 - Unable to get rid of links.
Mon, 12 May 2008 13:18:01 -0700
Workbook with multiple worksheets set up, worksheets having links to other
worksheets within that workbook.
A worksheet (with internal links) copied or moved to another workbook and
the links amended to the new (local) workbook, Saved and closed.
On reopening the new workbook, get message advising of exter ...
|
#VALUE! in cells when I open spreadsheet
Wed, 30 Apr 2008 09:51:02 -0700
I have a spreadsheet with links to other excel files. (All excel 2003). When
I open the spreadsheet, the cells all show #VALUE! until I open the other
spreadsheets that the links refer to. Is there any to fix this so that the
updates work without opening the other spreadsheets.
Thank you advance.
Tim ...
|
Links to mapped drive change to refer to local hard drive
Wed, 30 Apr 2008 06:14:01 -0700
We are running Excel 2000 under Windows XP. There are several spreadsheets
residing in a folder on a server to which 4 people have their O drive mapped.
These spreadsheets contain links to other files within these folders.
For 3 of the people, the links work perfectly but for one person, all the
links chang ...
|
Unwanted Change to File Name in Link
Mon, 28 Apr 2008 04:22:52 -0700 (PDT)
I have posted this in excel.misc but this seems to be a better fit.
Apologies for the duplicate Post
I have an Excel workbook (Call it A) that extracts version informaton
from a series of templates.
However if one of those templates is used to create a workbook whilst
workbook A is open, then the filename i ...
|
How can I programmatically change Link references?
Thu, 24 Apr 2008 08:31:04 -0700
We're doing a file system upgrade, and changing our server names. Our drive
letters, however, will stay the same (I: and J:), but will be changing from
something like:
\\filesrv1\ABC$
to:
\\filesrv2\ABC$
Subsequently, I have to help people sort out their links in Excel (and other
Office apps), and update ...
|
Determine what sheets are linked to sheet A
Wed, 23 Apr 2008 12:59:01 -0700
Hi,
I want to move a spreadsheet, call it Sheet A.
Is there a way to determine what other sheets link to Sheet A?
Thanks,
--
David ...
|
Excel 2007 data link update prompt
Wed, 23 Apr 2008 07:10:01 -0700
A user has recently upgraded from office 2003 to office 2007 on a Windows XP
SP2 machine.
This user used to receive a spreadsheet from a client via email to display
items ands costs, etc.
When opening up the file, the user received a message saying...
--------------------------------------------------
Th ...
|
|
|
Change formula to reference different external worksheets
Thu, 17 Apr 2008 15:36:40 GMT
Hi,
I have a master spreadsheet that has several sheets. Each sheet is reading
data from a separate external spreadsheet C:\Data using the below formula.
IF($AH5="","",IF('C:\Data\[Generic.xls]sheetTFF'!$A5="",A4,'C:\Data\[Generic.
xls]sheetTFF'!A5))
On each new sheet I want to recreate the above formula b ...
|
SEO Strategies
Tue, 15 Apr 2008 20:26:28 -0700 (PDT)
Is there anyone out there using any great SEO systems or programs to
help them increase their traffic and rankings in the search engines?
Please share...I will share the SEO program that I have been using
with very positive results. It is a 90-Day SEO coaching program by
Nancy Andrews called Live SEO Blueprint. ...
|
Hyperlinks
Tue, 8 Apr 2008 13:25:14 +1000
I have a spreadsheet which contains over 1,000 hyperlinks to a website.
Many don't work because they are missing two semi-colons.
Is there a quick way to check which ones have the missing semi-colons and to
insert them. There are two places in the hyperlink where they should
occur - always before &version ...
|
