Linking files 2 ways
I have a work book that is linked to another and vise versa.
Workbook A is where the input of data is made;
Workbook B has a link to the input from workbook A;
Workbook A retrieves the altered data back as a link.
Although this all works fine with both books open, I note that if I open
workbook A by itself, that the data it retrieves from Workbook B is not
updated . If However, both books are open, there's no problem. I thought
linked books were updated automatically if the Update remote references has
been selected?? But it appears that the second book is not updated until it
...Merging Two Office Data Files
This is a multi-part message in MIME format.
Here is the situation:
I've a desktop and a laptop. Before I bought the laptop I was using MS =
Outlook on my desktop. Now that I'm using my laptop mostly, I would like =
to have my old emails from my desktop Outlook merged with the laptop =
Outlook emails. I don't want to replace the laptop outlook files with =
the desktop outlook files is the folder - C:\Documents and =
Settings\Laptop\Lo...Reading SQL Server Extended Properties
I have an Access 2003 front-end (mdb/mde) connected to a SQL Server 2000
back-end. SQL Server 2000 offers the ability to add extended properties
(such as a caption, for example) to objects (tables, columns, etc.) using a
stored procedure called sp_AddExtendedProperty, along with the ability to
retrieve the values of these extended properties via a function named
With fn_ListExtendedProperty, four columns can be returned/selected using a
Select statement: objtype, objname, name and value. The first three columns
returned are of datatype sysname, whil...Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?
You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
swatsp0p's Profile: http://www.excelforum.com/member.php?...Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...Voice connector on Exchange server 2007.
Is there any functionality available in exchange server 2007 regarding voice
If not how can we create it?
Thanks in advance.
Exchange 2007 has the "Universal Messaging" role which is intended for this
purpose. Do you have a PBX?
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Microsoft Exchange 2007 command shell"
<MicrosoftExchange2007commandshell@discussions.microsoft.com> wrote in
> Is there any functionality available in exch...Reporting from Project Server
I dont know if i need to ask this question here or in the Access section. I
have an ODBC connection to the Project Server database so I can make reports
through Access. Access' limit of 255 fields per table is causing me some
trouble. for example, the MSP_VIEW_PROJ_PROJECTS_ENT table has well over 255
fields. Access only shows me the first 255 fields. how can I change that so I
can see all the fields in that table?
I have not tried this yet it may be a viable option. Have your DBA create a
view that pulls the key fields to this table and the specifi...Excel corrupts when asking to update vlookups
We are experiencing weird behavior with some Office 2K3 Excel spreadsheets
that contain lots of calculations, but no macros. On some pc’s Excel acts
normally, on others you get the error. I have a couple of screen shots
Any help is appreciated.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
Don Gu...Redirect Exchange 2000 IS backup to different Exchange 2003 server
I recently added an Exchange 2003 server to the same org as a 2000 server. I
have dbs from the 2000 server that I need to restore to retrieve email from a
user whose mailbox was moved to 2003. So I need to restore the db for that
mailbox from BEFORE it was moved because when you move mailboxes you lose any
deleted items that were being saved by retention policy.
Is this possible? I'm using Veritas Backup Exec 10 but nothing in their
support KB seems to follow this exact scenario.
If it helps, the old Exch 2000 server is currently empty of users and is
ready to be uninstalled. W...using the journal on outlook
Once I link an email to the journal, can I still find that email in my mail
box? I seem to be able to get to it only via the journal. If this is the way
it is supposed to be, how do I remove it from the journal and get it back
into my mail box? Am I just missing something?
Are you linking to the item or putting a copy into the journal item? Also,
has the item been archived or not?
"Independent" <Independent@discussions.microsoft.com> wrote in message
> Once I link an email to the journ...will CRM load on a 2003 server?
will CRM load on a 2003 server?
Microsoft CRM v1.2 supports Windows 2000/2003 Server.
>> Other Microsoft CRM Online Forum Resources:
>will CRM load on a 2003 server?
No problem. We just completed a 1.2 installation on a 2003 server, without
"Troy Hicks" <email@example.com> wrote in message
> will CRM load on a 2003 server?
CRM 1.2 will also load on Small business server 2003 as wel...Disable Secure Sockets Layer on exchange server when using RPC over HTTP
Hi im trying to enable RPC over HTTP to enable users to establish contact to
my Excahger server 2003 over the internet.
Now, I dont want to use SSL (security not that important) and i am told by
this article that i can disable SSL in windows registry.
Note While RPC over HTTP does not require Secure Sockets Layer, you must
modify the registry to enable RPC over HTTP if you do not want to use Secure
Sockets Layer. Microsoft recommends that you enable and require Secure
Sockets Layer for your RPC over HTTP communications.
At this address: http://support.microsoft.com/?id=833401
But i ...Pulling data from separate tabs
When charting in Excel 2002 is there a way to use sets of
data from two different tabs within the same worksheet?
For example, a spreadsheet contains separate tabs for
prior year and current year data. Is there a way to
reference the data or label series to pick up data from
I tried pointing and clicking, and then typing the
following as a reference for the axis labels:
='Prior Year'!$B$110:$M$110,'Current Year'!'$B$110:$M$110
but receive an error that I'm referring to an external
I've used the comma (') in the past to reference breaks ...How to automate increasing the form cache registry/file etc...
I want to roll out a batch file to make a number of tweaks to CRM
The body of it would go
REGEDIT /S Kerberosefix.reg
REGEDIT /S ForceFormreload.reg
REGEDIT /S OutlookFix.reg
It would also rename OSA.exe to OSA.bad
Remove OSA.exe From the startup menu
I need help finding a way to use my batch file to increase the Outlook
Form cache from the default 4MB to 50 MB.. This makes CRm more stable
and faster for communications. I dont want to manually do this, as it
time consuming, are my end users would not be reliable in doing it
I also want to make another batch file or button that...cannot open hyper links in outlook
when I try to open a hyperlink in outlook, I get the following message: This
operation has been cancelled due to restrictions in effect on this computer.
Please contact your system administrator. ----- I am the system
This is a problem with IE, not Outlook.
You need to reset your internet settings in IE's Tools, Internet Options,
Advanced tab. (Or Control Panel, Internet options, Advanced tab).
See http://www.slipstick.com/problems/link_restrict.htm for more
"Donald McNeely" <Donald McNeely@discussions.microsoft.com>...data sort
ok now should be simple >>
I need to sort by month on data that is held in format >> day/month
custom/ends with/ 11... does not work
custom/ends with/ ??11.. or *11 does not work either
contains 11 does not work (& would also be wrong if data set contained 1011)
but still I am stumped so any help would be great
I would be inclined to add a new, temporary field of formulas that pull off
the right 2 digits, and sort by that: =RIGHT(A1,2)
...get a result of an sql into a field
I would like to get a result of an sql execution (ms sql server) into aq
example i A1 I have a ID number
in A2 I would like to get the result of something like this 'select name
from address where id=A1'
Does this exist in Excel ?
Thanks in advance
Here is the sub i have written for loading an Sql Query into th
Target Sheet name
Column to begin from
Row to begin from
ex: CALL LoadData("MyServer","MyDataBase","Select UserName fro
"QueryData"...explanation of codes in Visual Basic when creating User form
I am trying to create a user form in Visual Basic however I'm trying to
teach myself by reading/watching tutorials. (www.contectures.o.ca, etc)
A lot of the instructions I am seeing simply give the code rather than
explain how to actually write one from scratch.
I need to know what each 'term' means so I can understand how the codes work.
Any help is much appreciated :)
One of the first codes is for the Add button
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("PartsData")
What d...MS POS = RMS? Also, SQL Connectivity...
I'm new to MS Dynamics software, and I may be posting this in the wrong
section - please let me know if I am.
I have recently opened a retail store, and purchased MS Point of Sale to
manage my POS functions. Is this software also called RMS? Is it a PART of
RMS? From what I can find online, I cannot tell.
Also, I'm interested in connecting to MS POS's MS SQL database with an
external program (OSQL) to automate some SQL queries at the end of each day.
Does anyone know what I use for the datebase name (master?), username (sa?),
and password? I cannot seem to find any doc...AR invoicing update GL but not receivables
We have an issue where the GL is updated with invoicing activity, but in some
cases the receivables side is not. Any piror issues with this, advice on how
to figure out the problem, etc?
I have only heard of the opposite happening - AR subledger is updated, but
the GL is not. Can you walk through exactly what happens? What type of AR
document in what screen? What is the 'On Account' amount? What are the GL
distributions? Where are you going to see that the AR subledger is not
updated? Where do you see that the GL is updated?
Microsoft MVP - Gre...Help with importing data
Can I have users fill in a form in Access and have that data be transferred
and updated to a spreadsheet. Need for fill out several fields and then
export to a specific spreadsheet and place that data into the cells that will
update that cell (add to the total in that cell) of a spreadsheet.
...mail queues for long on Exchange 2000 server time before being sent
I have a situation where all outgoing mail sits in a queues on the Exchange
2000 server (one per domain) for about 45 minutes before being sent. The
queues in question have a status of ready. There are also other queues of
that are retries (mostly NDRs from junk mail). We are only a small company
and the amount of mail is not great. What might Exchange be waiting for
before sending this mail? Is there something I can tweak to make it send
Thanks for any help,
Where does the mail go after it leaves your Exchange server, does it go to a
smarthost/isp or d...SQL 2005 Great Plains 9 issue
I will try to keep this succinct. I am running Great Plains 9 with SQL 2005
on separate servers. Recently I brought up a new SQL server(called sql02) to
replace the old SQL server(called sql01). After installing SQL 2005 on the
new server and restoring all the databases I renamed the new server(sql02) to
the name of the old Server(sql01). Great Plains worked happily after that.
On the new SQL server now called SQL01 there are two database engines in SQL
Studio, one is called SQL02 and the other is called SQL01. I would rather
not have SQL02 there, but I'm not sure how to delet...Formula for cross tab data filling
How to using formula for data filling as below (Y/N) ?
Product A Product B Product C
System A Y N Y
System B Y Y N
System A Product A
System A Product C
System B Product A
System B Product B