UpdateLinks Popup on Workbooks.Open 01-11-10
I have a refreshable Excel template file that is linked to data imported from
When I open the file using a Macro button with a Workbooks.Open sub, I get
an Update Links popup.
But, when I open the file directly from the network folder or shortcut, I
don't get the Update Links popup.
I have a temporary Workaround with an UpdateLinks:=False. But I would like
to resolve the issue without a bandaid.
Workbooks.Open "\\Network_Path\Category_template.xlsx", UpdateLinks:=False
'UpdateLinks:=False cmd is like clicking CONTINUE t...Restore Outlook 2003
I had a problem with my HD which required reformatting the drive.
Fortunately, I did have my outlook.pst file backed-up. I have now
reinstalled Windows XP Pro and MS Office 2003. When I entered Outlook, I did
not see my email messages or contacts. So, I copied my backed-up copy of
outlook.pst to the outlook directory (beneath the My Documents directory)
and clicked File/Open/Outlook Data File. Then they appeared in separate
places on my screen. I have several questions at this point.
1. Have I proceeded correctly so far in trying to get back to my original
state before the HD problem?
2....Install OWA 2003
How to install OWA2003 in one another server, separate of the server of the
Examplo, in server WEB.
You can't. OWA is now integrated into Exchange and cannot be separated like
you could with Exchange 5.5 installing only OWA.
"Alysson" <email@example.com> wrote in message
> How to install OWA2003 in one another server, separate of the server of
> Examplo, in server WEB.
&g...Exchange 2003 getting clogged?
A client of mine wrote me the following IM's earlier regarding his boss's
email account. It appears that there hasn't been any change in
configurations on the server and that it was just noticed today/very
recently. While I'm not an Exchange2003 expert, I have used it a little and
never ran across any clients that have used it before until now. Does
anyone have any suggestions at what route to take when reading this? I
admit this discussion with me and the client seems to be broad, but I was
trying to gather as much info as possible to troubleshoot:
Clie...2000 Server Connection to 2003 over VPN
Here is my issue:
My company has a remote office in Montana. We have 2 Cisco 501 Pix
connecting the sites via VPN. The 2003 Servers from WA can see the
Montana office with no problem as can all the Workstations. The 2
windows 2000 SP4 Servers however can not see the 2003 server in Montana
or vice versa. When pinging the servers from either side it does reolve
to the correct IP however the ping drops. Every other IP connects fine.
Something in the 2000 servers are blocking the connection over the VPN
any ideas would be great...
SOme things to check:
DNS zones on both ends, st...copy/move sheets within workbook
When I try to copy sheets in a workbook to another sheet in the same workbook
I get the following error message:
A formula or sheet you want to move or copy contains the name 'aa', which
already exists on the destination worksheet.
This repeats many, many times until it ends with something like
'zzzzzzzzzzz'. How can I preclude this from happening? I don't have any
named ranges in the sheet/workbook that this occurs in. Has anyone seen this?
>>I don't have any | named ranges in the sheet/workbook that this occurs in.
Yet Excel thinks you do. Grab the N...Outlook 2003-Does Not Terminate
I was noticing that my computer would take an inordinately long time (like
10 minutes) to complete its shutdown from time to time. I've finally
isolated the problem-- it only occurs when OUTLOOK.EXE is still shown as a
running process in the Task Manager. (Note that the APPLICATION is not
running, just the process, showing 16,788 KB.)
I've tried using the END PROCESS command, but to no avail. (I get the
warning message, and click YES, but nothing happens.) How can I find out
what's causing this, and how do I stop it from happening? There doesn't
seem to be any rhyme...2 Files Open In 2 Instances Of Excel #2
Thanks for your help.
I fully understand your reasoning over the dislike of using this, fo
But thanks for you help.
I have added the following into my workbook coding
Application.IgnoreRemoteRequests = True
To turn this option on only when the specific spreadsheet opens, an
Application.IgnoreRemoteRequests = False
within the button that closes it, so that this does not remain th
default, as not to cause others a problem using other spreadsheets.
Thanks again for all your help.
:) :) :) :) :
----------------------------...How to rebuild public folders in Exchange 2003
I have run into a problem with a migration from Exchange
2000 to Exchange 2003. The public folders appear to be
messed up. This stems back to a migration from 5.5 to
2000. At this point the public folders are empty. I
would like to rebuild them, but am looking for the best
approach to do this. I have seen article 822444, but it
also references rebuilding the public folders.
...Sort Inbox items by Unread in Outlook 2003 doesn't work
I customized my inbox view to sort items by unread. Unfortunately, the
messages are not sorted have read and unread messages intermixed in my inbox
(sorted by date). I wanted unread messages first then read messages
afterwards. The primary sort would be unread ascending (descending didn't
work either) and secondary sort would be by date. The group by is none
since unread was not an option and automatically group according to this
arrangement is turned off (tried with it on & didn't work either). The
inbox shows that it is arranged by custom.
Any suggestions on how to fix this...How to change where Outlook 2003 saves attachments
I have followed Microsoft's instructions on how to change where Outlook
2003 saves attachments. Those are found in Knowledge Base Article
#823131 and involve changing the Registry. (There really should be an
Anyway, despite having followed those instructions explicitly, Outlook
continues to save emailed attachments in a folder buried deep in the C:
drive that doesn't even show itself when I navigate to it (and even
when I set folder options to show hidden folders). Just to try
everything, I did a completely clean reinstall of Outlook and then
followed the Registry edit ...How do you keep charts
When copying a chart or graph, it doesn't keep the size of the original chart
or graph (length/height). How can I keep all of the charts-graphs the same
size when copying?
...new excel 2003
I work in a small office and wonder if we should buy the
new Excel 2003 to upgrade from Excel 2000 that we are
currently using. I cannot find anywhere that tells me what
the upgrades are. I also want to find some support I can
get to explain the differences. thnx
It's probably not worth the price of the upgrade.
There's really not much more that you can do with 2003
that you can't do in 2000.
One of the Excel gurus who has written some excellent
books on Excel (including 2003) has a review on his
Take a look here:
...Outlook 2002 Note does not show when you open a VCard
I have Outlook 2002, and when I export a contact that has
Note field in it into VCard and then re-open it, Outlook
does not show Note field, although it is filled in the
body of that VCard.
Has anyone experienced this problem?
Does anyone know how to deal with it?
...How do I stop warning messages everytime i open a hyperlink?
Just a short description of your software and your problem might just
help us try to help you.
The actual text of the error message often gives the odd clue to the
Wot's Your Real Problem?
...Upgrade from SBS 2003 to Standard 2003
Can anyone help me please?
I have an sbs 2003 server and we want to change everything to the new
sever we bought which is running standard 2003 r2.
We only use our server as a file and print. So all we need to to be
bale to transfer the users etc and have them logon with no issues ie
changing profiles etc.
Can this be done?
PS, really dont want to get involved with transition packs etc.
jonoharper's Profile: http://forums.techarena.in/members/171848.htm
View this...Convert to Outlook 2003
We are receiving new pc's which have Windows XP and
Users vary on operating systems and Office Versions.
What are the correct step to bring over there pst files?
Or maybe we shouldn't. But I need to know what the steps
are to install there Old
Messages/Folders/Contacts/Tasks/Calendar Items etc. from
old pc(various Outlook versions 2000 prior) to new pc
which now have Outlook 2003. I have tried a couple of
ways but I keep getting a duplicate personal folder which
is also active. (Example if they get a new mail message
it goes to both inboxes in both personal fol...Copying data but keeping original
I have two spreadsheets with several rows of data on each of them, they
both have header rows, with the same heading names. I want to copy the
data from spreadsheet 1 ( without the header row) to the spreadsheet 2
but keeping spreadsheet 2 original data ( i.e NOT REPLACE ) i just want
the data on spreadsheet 1 to be pasted on after the last line of data
on spreadsheet 2; as i need to keep the existing data in spreadsheet 2.
Any ideas on how I can do this with a macro or VB code?
Help appreciated thanks!
See Ron de Bruin's site for various copying macros.
http://www.rondebrui...outlook 2003 new mail sound
why doesn't 2003 play a sound when new mail arrives?
yes i have set it up in windows sounds and it still doesn't do it
You mention that you have it set up in Windows....do you
have it enabled in Outlook? Click Tools, Options,
Preferences, Email Options, Advanced Email Options, and
ensure it is checked under new mail options.
>why doesn't 2003 play a sound when new mail arrives?
>yes i have set it up in windows sounds and it still
doesn't do it
> You mention that yo...Exchange 2003 Standard
Our Exchange 2003 Standard Edition server's Public Store has exceeded the
16GB limit and shut down. I'm familiar with the temporary extension to 17GB
one can do for the Mailbox Store but haven't found a KB article regarding
temporarily expanding the Public Folder store. Is this possible and if so
Temporary solution found - the same registry entry mentioned in KB828070
except located in the public folder key does the 1GB increase.
"MS Newsgroups" <firstname.lastname@example.org> wrote in message
> Hi all,
...unable to paste Excel 2003 chart into Outlook 2003
I have a user who's unable to paste an Excel 2003 chart into Outlook 2003
email message. In Outlook options, the checkbox is selected for "Use
Microsoft Office Word 2003 to edit e-mail messages".
When I tested this on my own computer running the same version of Office, if
the box is check, I have no problem pasting; if this box is cleared, I
cannot paste. But on his computer, it doesn't work regardless.
Thanks and regards,
...size of window upon opening a spreadsheet
Operating System: Mac OS X 10.5 (Leopard)
When I open my spreadsheet, sometimes it opens to a window that only shows the cells I want to see. Other times it opens showing those cells plus several rows and columns larger. Why does it not always show the area that was shown when it was last saved?
I'm not sure I have the 'absolute' answer because I experience the same sort
of thing once in a while � not just with Excel or Office, but a variety of
file types. However, the way it reputedly works is that the window size
retained should be whateve...Contacts in Outlook 2003 (and other Office 2003 atrocities)
Every time Microsoft does a new improved version of Office it ruins what few
features it had before that worked. Going to Office 2003 (from 2000)makes a
real mess of almost all of Office (it ruined what formatting I had in
WORD -- the numbering goes to some default that MS thinks I *should*
want). It also makes it impossible for me to find people (not CONTACTS,
these are FRIENDS) I had in my address book in Outlook. For example I used
to be able to type in my friends' nicknames, but that doesn't work in 2003
(the nickname is there alright, but you can't retrieve them by typing t...Allow smartlist exports to have a spreadsheet open to import to
In version 9.0 of dynamics gp this functioned as we need. Now it always
wants to import into a new spreadsheet.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=91414c32-...Error when sending pub 2003 document as an email
we have a document that we have been sending as an email in publisher 2003
for some time, by using the SEND AS EMAIL> SEND THIS PAGE AS A MESSAGE. This
has worked fine for some time, but now something has happened to the document
that when you click the send button in outlook you get a message that
publisher has encountered an error and needs to close. Outlook then freezes
and has to be cntrl-alt-del to kill it off. this happens with the same
document on multiple computers, whereas the same computers can complete the
task using a newly created document. Anyone seen this before?