I'm doing a projection spreadsheet. The new months in diff sheets will be
added as and when the actual month passes, ie, up to now i have sheets up to
Aug. But in the MAIN sheet, I'm supposed to have months for the whole year up
to Dec. Since Sep to Dec don't have equivalent sheets yet, the cells show
#Ref since my formula is =Oct!A1.
I want to tell the cell to get the amount from "Oct" sheet if there's such a
sheet and if not, get the amount from "Sep" sheet. I tried this
"=if(Oct!A1="#REF", Sep!A1,Oct!A1)" but it doesn'...Office XP Exel
Scenario: User's A,B, C, and D all have access to an excel XLS on a 2003
server. Users A & B have modify rights, users C&D only have read rights. If
user A updates the file, the general tab in properties reflect the exact
time the file was modified. After user A saves and closes the file, user D
goes in. The changes are there, but in the properties general tab, the
modify date in an old date (probably the actual creation date). Is this
normal ? Any idea's ?
...Excel template issues
I have a user that has a excel template on his network home dir
NW 5.1 Server
he says that after he creates a new file from that template - he goes to
open and it tells him read only access
running Excel 2000
...Public folder issue, "messaging interface has returned an unknown error"
I'm running a SBS2003 domain and just added a public folder and a
customized form for entry into the public folder. All of our clients
(all XP Pro, Outlook 2003 with all updates) can get to that folder and
use the form without any difficulty except for one. On one computer I
get the classic "The messaging interface has returned an unknown error.
If the problem persists, restart Outlook." error message.
I have tried a repair install, no change.
I have tried making a new profile, no change.
I have tried adding / removing his PST file (currently he's not even
using a pst file...Terminal Servers in Cluster - Login/Profile Issues
Currently I am having an issue with logins and profiles as per details
Server/Network Configuration Details:
1 X Windows Server 2008 Std FE 64bit (DC)
2 X Windows Server 2008 Ent 32bit Terminal Servers
User Profiles are Roaming and exist in: \\SBSERVER\Profiles on the Domain
Controller and C:\Users\ on the Terminal Servers.
Approx 50 users.
Error messages when logging in the terminal servers: Your roaming profile is
not synchronized correctly with the server. Windows will load your
previously-saved local profile instead. See the pre...Issue with Loan Accounts
I have been having this issue for a while - but just now trying to figure
out what's happening. I have several loans (including car, equity, etc.)
which I have set up on Money 7. Sometimes the interest and principle are
calculated correctly - but more often, the entire sum of the payment is
allocated to principle (as viewed in the account register). I've check to
insure that the loan is set up okay - and it looks okay to me. Any ideas
what's happening to me?
Any help appreciated. Thanks. Patrick
I was really hoping someone would respond to this. My ...time formats #3
I have an Excel sheet with a long list of times spent on various projects.
The times should all be in minutes and seconds. The first time reads 2:29
and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it
reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is
right, for 40 seconds. But in the formula bar, I see 12:40:00 AM
I want numbers, but apparently I am looking at times.
I tried changing the format. When I check the format for 2:29, it comes up
Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but
that changes the displa...Multiple Language Issues
Has anyone successfully manually updated a non-English supported 5.5 to
2003? (The reason for the manual update was a broken admin account.)
Mail and contacts were all exported to PST files, and then imported to 2003.
However, although the text of the messages is fine (English and Russian),
the text for contact names and message subjects gets gorched if they
contained any Russian text.
Does anyone know the correct sequence to follow to take messages and
contacts in Russian (or other languages) from 5.5 to 2003, while retaining
the non-English subject lines and contact names?
...New Computer #3
How do I move my settings, emails, address book, etc...
to my new computer. I'm mostly concerned with Outlook
because it's the program I use most often. I have an
older computer running WIN2K Pro. I purchased a new Dell
computer with Windows XP Pro also with Office 2003. Again
how do I make my new Outlook have all the information and
settings that my old computer has. I do have both
computers connected on my home network and they can see
each other. But I'm not sure what to copy over. Any help
would be very helpful. Thank You, Paul
The file you need to copy and re-use up ...CRM 3.0
Any way that we can assign leads / opportunities / other entities to teams
rather than individuals?
All the best
Team ownership is not supported in CRM 3.0. Could you describe your
scenario, and maybe we could provide some alternatives?
Microsoft Dynamics CRM
This posting is provided "AS IS" with no warranties and confers no rights.
"Electronic Workplace" <info@electronicworkplace.LoseThisBit.com> wrote in
> Any way that we can assign leads /...Importing #3
I had a previous version of Money and just got a new
computer with Money 2004. I have a backup disk made with
the info from the previous version. How can I import that
into the new version?
<firstname.lastname@example.org> wrote in message
> I had a previous version of Money and just got a new
> computer with Money 2004. I have a backup disk made with
> the info from the previous version. How can I import that
> into the new version?
...Debt Reduction Planner #3
The debt reduction planner on my version of Money 01 does
not take the minimum payment due into account. It expects
me to short some accounts to make bigger payments to
other accounts. Obviously that is not feasable, as the
late charges for not making the minimum payment would
negate any possible savings. Is there a way to fix this
so at least the minimum payment is listed?
...Converting from Lotus 1, 2, 3 docs
I have a user who has a bunch of Lotus 1, 2, 3 spreadsheets that he is
trying to convert to Excel. His version of Lotus is old (version 5), his
version of Excel is 2000 sp2. The files convert but they are missing pages
or headings or other unacceptable qualities. Anyone any advice?
If you open the files using Excel and save them to an .xls format in the
current version you are losing data?
A while back I needed to do this. I wrote an application in VB that loops
through the files, opens them using Excel (add a reference in VB to MS
Office 10) and then save them in the current ...Calculating dates #3
Can anyone tell me what I should use (in the way of helper cells)
to take any date (mm/dd/yyyy) and turn it into that same month
and day for specific year? For instance, turn...
10/12/2009 into 10/12/2010
4/6/1998 into 4/6/2010
I'm trying to determine anniversary date based on start date and
do it starting in 2010.
Assuming your date is in A1.
Hope this helps.
On Jan 5, 5:35=A0pm, Jordon <jordon@REMOVE~THISmyrealbox.com> wrote:
> Can anyone tell me what I should use (in the way of helper cells)
> to tak...Money 2005 Password Issue
I have been using Money 2005 for about 8 months and suddenly I cannot sign in
using my usual hotmail.com passport. The error message is "the e-mail address
or password is incorrect". However, I can sign in using the same e-mail
address/password pair to hotmail and MSN Money in IE.
I've tried KB Q331123 but no luck.
1) I can get into my Money file in offline mode
2) I even tried to change passport password. The new password works in IE,
but not Money.
> I have been using Money 2005 for about 8 months and suddenly I cannot...Cell References #3
I have 2 separate work sheets. I want to copy the values of cells in work
sheet A to cells in Work sheet B. The values in A are separated by at least
4 rows. Cells in B where I want those values are separated by 1 row.
How can I copy the values without having to enter each cell reference
indivudually in B?
Is there a formula to add columns or rows such as cell A1+3 = cell D1 or
cell A1 + 3 = cell A4
> I have 2 separate work sheets. I want to copy the values of cells i
> sheet A to cells in Work sheet B. The values in A are separated by a
> 4...Sent faxes in CRM 3 doesn't show in history
I am reposting this as I've had no answers to my previous post which is now
buried in all the other ananswered posts. Surely someone knows the answer to
this??? It's pretty fundamental to what customers will want. Anyone???
I'm using CRM 3 under SBS 2003.
When I send a fax using the "New activity / Fax" option within a contact
record it sends successfully. . However there is no record of it stored in
the contact history?
If I check the fax console on the server the fax has been sent (also
verifi...Graph question #2
Quick query with regards to how data is read by a graph. I have a sheet
featuring the number of staff assigned to the call centre at 1/2 hour
points throughout the day. This data is stored in a sheet called 'Data'
and in cells D17, E17, F17 etc etc.
The data within this page is not very well presented as it is run
automatically from the system we use here so I have made a more
presentable table and graph. For the table for each 1/2 i simply
reference the cell in the data page so that all i have to do to update
the sheet week by week is paste fresh data in. Using =Data!D17 t...Native Resolution Issue
I have 298 laptops my section supports and recently we started running into
issues with higher native resolutions. Some of our users don't like the
higher resolutions because it makes everything too small, so we adjust them
to lower reslutions, but the settings revert back to the native resolution
whenever the laptops go to sleep, get removed from the dock or if someone
else logs onto them. We use HP and Dell laptops with various models. Is
there one setting in Windows XP Pro SP3 where we can "turn off" native
resolution? Thanks for any help
J Wilson ...Issue opening documents in MSOffice 2003
I wonder if anyone can answer my question? I have a new laptop running
Windows 7 Pro with Office 2003 and I notice that when I seek to open an Excel
or Word file with a .doc, .docx, .xls or .xlsx extension, that Excel or Word
opens the file but also an empty window of opens at the same time, e.g. I
have two windows of Excel open, one with the document I want and the other is
Is this a default action for any reason or a bug? This is more of an anomaly
than a major issue but I am curious?
Any advice would be welcomed.
"...Outlook Express address Book #3
My address book is no longer visible. How do I correct
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program despite its similar name..
You will probably get a faster and more expert answer if you post this to an
outlook express news group.
Try posting in one of these newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
microsoft.public.windows.inetexplorer.ie55.outlookexpress for OE 5.5x
microsoft.public.windows.inetexplorer.ie6_outlookexpress for OE 6.x
...Analytical Accounting Error #3
I am getting the error 'This record has been created since your attempt to
create. Changes will not be saved'. This I am getting while I am trying to
add additional transaction dimension.
...IF statement with FALSE value being text AND cell reference? #3
Once again, figured it out on my own. Oh, and thanks for the repl
Needed to use the ROUND function:
=IF(D9>1,D9*D8,"<" & ROUND((D9*D10),2)
jcob2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560
View this thread: http://www.excelforum.com/showthread.php?threadid=27157
...Strange ADC issue
This problem is really strange. Here is the background. We have a 2003 AD and
several Exchange 2003 SP1 in this AD forest. These 2003 servers are all part
of 5.5 sites. We have an Exchange 5.5 server that is located overseas in it's
own 2000 AD forest. The connector is setup to create disabled accounts in our
2003 AD when a new user is created in the 2000 AD. We had a user in our
domain that transferred to the overseas location and instead of deleting his
account in our domain, we hid it and then renamed it to the replacement
credentials. The 2000 domain admin overseas created a new...2007 RDP issue
I RDP to my home PC that has Money 2007 and it keeps redrawing the screen and
This was annoying in 2005 but eventually it would calm down and you could
use it, but now you cant
Just need a simple start screen or way to bypass etc.
I use Remote Desktop with Money 2007 Premium across my LAN
It works flawlessly.
Are you using it across the internet?
Are you using the new version of RDP? I think it's version 6.0.6
"Michael" <Michael@discussions.microsoft.com> wrote in message
>I RDP ...