Use code to stop "...contains one or more links that cannot be updated"
I sequentially open then save & close about 30 files from a list in
master spreadsheet. I am receiving the link related messag
"...contains one or more links that cannot be updated" on open of eac
file. I need this message to be stopped from displaying by usin
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
> I sequentially open then save & close about 30 files from a list in a
> master spreadsheet. I am receiving the ...copying wkshts from one workbook to another
I am having trouble getting my code for copying worksheets from one
workbook to another to work. Here is my code in its entirety:
Dim rngAllFiles(), rngSelectFiles(), m, fileSaveName, wkshtName As
Dim a, s, i As Integer
Dim newBook As Object
rngAllFiles = Array("1 Cover.xls", "2 Table of Contents.xls", "3 Top
Ten.xls", "4 FX Impact.xls", "5A MTD IS.xls", "5B QTD IS.xls", "5C YTD
IS.xls", "6 Sales-Internal.xls", "7 Sales-WS.xls", "8A MTD GM.xls", "8B
QTD GM.xls&...User removed Anonymous permission from Calendar...how to get it back
A user has deleted the Anonymous permissions from their calendar and I am unable to find a way to get it
back. Does anyone know what can be done to add this back to their calendar. TIA
Fuzzy Logic <email@example.comREMOVETHIS> typed:
> A user has deleted the Anonymous permissions from their calendar and
> I am unable to find a way to get it back. Does anyone know what can
> be done to add this back to their calendar. TIA
In that user's Outlook, right-click on Calendar, properties, permissions
tab. Add Anonymous, and do whate...Getting text to appear in another sheet
I'm working with two worksheets: Sheet 1 and Sheet 2 (I'll call the
this for simplicity). I want to get the data (text) in Sheet 1 int
I know how to do this using =Sheet1!C1 (etc.)
However, not all the "C" cells in Sheet 1 have text. I only want tex
to appear in Sheet 2 (cell "A") when there is actually text in the "C
cell of Sheet 1. Is there anyway of doing this without getting th
default "0" that it puts in when there is no text.
As I read this it sounds like a tounge twister, but hopefully someon
can help as my Excel skills only go so...navigation bar links
My navigation bar does not link correctly to all of the pages of my website.
I have added pages and moved them around to get them in the right order.
They do not link correctly when I preview my website. Any suggestions?
Nevermind. I got it.
> My navigation bar does not link correctly to all of the pages of my website.
> I have added pages and moved them around to get them in the right order.
> They do not link correctly when I preview my website. Any suggestions?
...Exporting calendar in csv file
Hi, i am experiencing troubles in exporting calendar records to a csv
Office 2003 professional sp3, XP Pro sp3.
When I try to export Outlook crashes. The csv file is created, but it
misses most events.
I have records from 1999 to 2014, about 8000. If I export one single
year, for some years exporting to csv works, for some others doesn't.
If I split calendar records in more than one pst file, or create a new
pst file importing the records, and than try to export in csv, Outlook
I have tried on more than one pc, also with Office 2007, but the same
issue happened, s...Link Subform to Subform
I was wondering if someone could help:
I have an unbound form with 2 subforms. On the unbound form, i have an
unbound combo box (cmbo_name) that displays a list of names. When a name is
selected, the person's details are shown on the first subform (works
perfectly) what im having trouble doing is linking the first subform to the
other subform so when a selection is made in subform1, it's details should
appear in subform 2. Does anyone know how this can be done??
Message posted via AccessMonster.com
Hi ...Calendar Template with week numbers
I am looking for a calendar template that has a column with week numbers. It
should also include the dates associated with that week in the other columns.
Start from A2, with the numbers 1, 2, etc downwards, until 53.
Start from B1, with the numbers 1-7 to the right. These stand for
Sunday through Saturday.
In B2 use the formula:
This will work for the current year. If you need other years, enter the
year in a separate cell, e.g K1, and substitute $K$1 for the expression
YEAR(TODAY()) where...Prevent Outlook Calendar from deleting old information
I was unaware that when performing the archive function it does not archive
your calendar entries as well - apparently after 6-months you are left with
totally blank boxes. went into the Calendar archive folder - nothing there.
How do I prevent these valuable business records from automatically deleting?
How would I retrieve this information?
Archive only archives if you tell it to. Do you sync with a smartphone?
Syncing with a smartphone when the phone is set to keep old appointments for
less than 'forever' will delete them from outlook calendar.
Diane Poremsky ...how do i link cells so that when typing in an item, the price app.
I'm trying to create a quotation template which enables me to enter in an
item in one cell and its corresponding price appear in the next cell? Is this
I have created a spreadsheet of Items and prices (of which there are going
to be over 1000) as a refernce point but am unsure how to link these for
automatic entry into the quotation.
Anyone know how to do this?
You need to build a table of the items and prices. For
example, on sheet2 in column A you list the items and in
column B you enter the corresponding price. Assume that
table...copying data from a cell in another worksheet
What formula do I input in a worksheet cell to reproduce data from a cell in
another worksheet within the same workbook?
Thanks in anticipation.
This is a quetion one would ask in the first hour of his/her first
excel class.. and like any other question needs to be answered.
1. Select the cell where you want to put the formula
2. type = or + sign and then using your mouse select the sheet and then
cell (in it) which you want to refer to (its easier for a beginer to
use mose rather than keyboard)
3. Press Enter
...Linking worksheets (ex. =sheet1!B2)
What I want to do seems so simple but Excel is doing some
weird stuff and I'm stumped. I'm starting with two
worksheets. The first is my raw data template. The
second is my summary page, made up of simple formulas,
many of which are referencing cells from the raw data
worksheet such as(=detail!B2). This initial setup works
fine. What I want to do now is re-use the detail
worksheet to produce multiple summary pages for individual
products. My method was this:
1. Make copy of summary worksheet
2. Rename new worksheet (new worksheet has the same
formulas as original)
3. &qu...Updated appointments stay in calendar
When an appointment has been updated we have found by
several clients that the appointment that was updated
stays in the calendar causing a double appointment. The
old appointment is not automatically removed when the new
appointment has been accepted.
Can anyone please let me know of a solution to this
problem. thanks, Yvonne
...Changing the calendar color (NOT the service Calendar)
We're trying to find a way to show activities with different colors based
on a type field on the appointment itself in the regular calendar. Is there a
way to do this?
I know that you can change the color of the Service Calendar depending on
the status of the activity, but that's not what I'm looking for.
On Mar 2, 2:20=A0pm, Fred Bang <FredB...@discussions.microsoft.com>
> =A0 We're trying to find a way to show activities with different colors b=
> on a type field on the appointment itself in the regular c...Linking
Hi everyone, i have a sheet named: Employee Data, but i would like t
link this to Microsoft Access so that when the details of an employe
are entered in a form at Access, it is automatically inserted int
Excel too, i should be able to delete, edit and add details o
employees, and it should take into effect at Excel.
How do i go the right way with this? Thanx, regards
Message posted from http://www.ExcelForum.com
Adn4n, open your Access database and File > Get External Data > Link. Go
through the steps and, when you're done, you'll see the little Excel icon
with the arrow n...Making one cell in another row equal another all the time
For example, the reason I want this is that as part of my excel workbook, I
keep car mileage broken up into personal and work. I have the date, the
starting number and the cell after that the ending number then after that
"w" for work or "p" for personal and then I made the difference between them
come up under either the personal or work columns. However - and quite
obviously - the ending number on one row is the exact same number as the
starting number on the next row. So what I want to do, if possible, is to
make the starting number on the next row ALWAYS fill in ...Trouble synchronizing Oulook 2002 calendar with my Clie T-615
Up until I performed an update to my MS Office Professional 2002, I could
view appointments in Outlook and they would synchronize to my Sony Clie PEG
T-615C, which runs Palm OS 4.1. Now, after applying the latest patches, my
Clie cannot pull some meetings from Outlook. Also, the reminders are
I have looked at the Clie and Palm sites to no availe. Any suggestions?
...Maintain formatting in linked chart title
I am linking an Excel chart title to a named range. Is there any way to
maintain the formatting used in the named range in the chart title?
On Tue, 15 May 2007, in microsoft.public.excel.charting,
chumley <firstname.lastname@example.org> said:
>I am linking an Excel chart title to a named range. Is there any way to
>maintain the formatting used in the named range in the chart title?
Not ordinarily. Someone may be able to do it using VBA.
NB Personal replies to this post will send email to email@example.com,
which goes to a spam folder-- please send...Pub File linked with Excel File?
I wish to transmit (Via Email or to be Downloaded) a pair of files - one
Publisher linked with data in an excel file. How may i accomplish this w/o
breaking the link?
...link with .mdb
I have created a access database and placed it on our
share drive. I have copied and pasted the URL or file
location into an email so that when someone receives it
and clicks on the URL it launches the database.
On some computers this works great - on others I get a
warning message saying I have to download the attachement
before viewing it - which defeats the purpose of the
We all have Office 2000. Is this an Outlook security
issue? I have tried changing the security setting but so
far no luck.
Nevermind - I found the answer.
Given my earlier problems with merged cells and copying
(see earlier post) and the advice to avoid using them like
the plague because of the problems they bring; has anyone
found a way of producing the effect of merged cells (
titles spread nicely over several columns)without using
the facility, apart from judicous use of the space bar?
Thanks for your ideas.
Select the cells
Format > Cells > Alignment
In the Horizontal drop down select "Centre across selection"
Norman Harker MVP (Excel)
...can not open linked table
When trying to open a linked table I get an error message that the file is
opened exclusivelyby another user. I have used this link before many times
and have knowingly done nothing to change it. I am using acces 2007 on a
vista lap top to an access 2000 database on a different computer (xp) which
uses access 2000 .
If you are certain that you are the only user, close Access and delete the
LDB file on the remote computer. If there is more than 1 user, 1 or more
have the database opened exclusively. Go to Options on each computer using
the database, and change that.
I have a workbook which contains several worksheets which are used to
calculate information for a report. The report pages are the first couple of
worksheets formatted and which contain graphs linked to data on other
worksheets within the workbook. I wish to make a stand alone version of my
report, capable of being Emailed.
I can copy the report pages to a new workbook, and then replace the formulas
with values without issue. I can then delete all the names thus removing
more references to the source workbook - however now my problems arises.
The graphs which copy across and look the same, a...How do i Change links to Relative links for linking pdf files?
Using Publisher, how do i change a link from absolute to relative.. I ahave
created an offline website as a demo CD to hand out to clients, but the
linked PDF's will only work when the CD drive of the computer is D:, how can
i make the link read from the CD no matter whats the drive directory is
When you are in the hyperlink dialog do not browse to the file to set the
link. Use the address option and enter the path you want.
David Bartosik - [MSFT MVP]
"Riggaz" <Riggaz@discussions.microso...Link from other workbook
I try to create a link which provide value, where the link path is determine
from another cell, unfortunately b8 return a string value. How to make it
evaluate to return actual value of c:\abc.xls category worksheet $a$8 value?
7 Path Def Data
8 c:\abc.xls ="'["&A8&"]category'!$A$8"