The reference below is in an entire column of cells. The cell C7 is a
number (14,000) that appears to be a constant multiplier for the entire
column. I'm trying to find out what the , in front of the cell reference
signifies, and what "TABLE" is being referenced.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
Mike Polo wrote...
> The reference below is in an entire column of cells. The cell C7 is a
> number (14,000) that appears to be a constant...Mysterious Filling of Disk Space
I am experiencing a new problem with Outlook 2007. I can think of no change
that has been made to cause this problem. My PC has limited space free as it
uses a Solid State Disk. In reality there is usually around 1.5Gb free.
When I start Outlook the free disk space will be rapidly consumed such that
it is all gone within about 15 minutes and applications start o fail. This
is annoying with Outlook because it corrupts the setup and requires me to
reset the navpane.
If I shutdown Outlook the disk space stops being consumed but is not
released. When I reboot, the disk sp...Loads of Mystery appointments (mysteriously deleted)?
Here's a wierd one... there are hundreds of deleted appointments in my
deleted items folder they are all scheduled for 'Tue 01/01/1980' and in
every other respect resemble an appointment that I was invited to about a
The appointment is titled 'Michelle at Pearsons', and each one in deleted
items, has a partner called 'Updated: 'Michelle at Pearsons'.
But I haven't done anything with this appointment at all - for about a
year - I only discovered them recently when Google sync alerted me to the
fact that I'd deleted 12 appointments today....Mysteriously Deleted Files
Hello, this is my first attempt at a newsgroup and I'm
hoping that someone might know what's happening to this
system I'm working on.
The computer I'm dealing with has Office XP pro installed
on it, and recently the shortcut links on the left side of
excell relayed an error message concerning the files being
missing. I used the search function to locate all of
my .xls and .doc files and only the hidden and system
files returned as matches. I then looked the nortan
protected recycle bin to see if any files had been deleted
and possibly be restored, and a few excell f...Calculation mystery
I have problem with calculations in a program produced using VC++ and
MFC. The calculation is using double floats. It loops until the result
is reduced to a target value.
In debug mode the calculation needs 178 loops. In release mode the
calculation is not consistent and sometimes needs over 38000 loops.
I think this must be something to do with double floats in debug mode.
I can't fathom out what could cause the loops to vary in release mode.
It shouldn't change from run to run and it doesn't change in debug
EasyNN-plus. Build Neural Networks. ht...Mystery Calender Filter
I've got two different users Active Sync'ing their Treo 700w phones with
Exchange 2003 mailboxes over the air. All works fine except when an
appointment is made in the handheld calendar, it doesn't appear on the
desktop Outlook Calendar. Shows up in OWA and time alerts fire off just
fine in both Outlook and OWA - you can even go to the event in Outlook.
There must be some filter applied to Outlook, except when I go to:
View -> Arrange by ->Current View -> Customize -- Filters are reported as
Is there another place to be looking where some filter may be being...It is a Mystery to Me...
I have Pub 2003 & Windows XP.
My goal is to create a Folded Card with 4 pages looking all the same. What I thought it would work is: Page Set Up - Properties - Finishing - Pages per Sheet and chosen 4. (If it is not for multiplying the existing page then it is what for???)
I thought that I will get all the 4 pages looking same. The result was one tiny page (4 times smaller then it should be
I know about the Help Option but not knowing what to type into I could not use it
“In the Cookie of Life Friends are the Chocolate Chips.�
A small child turns to Ed, and exclaims:...mystery in my View
I have a SetMetrics() function that is called in the initial call to
OnDraw(), and a SetExePath() function that is called in OnInitialUpdate().
After making extensive changes lately, I am confounded by a problem with my
View. Somehow, at least 2 of my variables ( m_nWidth and m_strFilePath)
seem to be losing their values somewhere along the way. Would anyone have a
suggestion to help me troubleshoot this puzzle?
m_nWidth = rect.Width();
. . .
TCHAR buffer[_MA...Mystery account balances
Just recently we notices something hinky going on with our accounts
receivables. For instance:
Scenario 1: We set up a customer account; he put $173 on the account to
prepay for goods. If you look at his account it shows ($173.60), but
the Running Balance shows ($397.20). There are NO other transactions.
Scenario 2: A customer purchased goods for $42.36. The running balance
shows $42.45. Where is this money coming from?
Is there a hotfix out there for AR's? It really bothers me that I can't
trust my accounts.
I think that in the instance of #1, th...CListView and TVN_SELCHANGED mystery
I have a class named CNetTreeView, which is derived from CListView. The
message map contains the following entry:
which calls OnSelchanged whenever the tree selection changed. However, a
call to GetTreeCtrl() within my OnSelchanged() will fail, and I found that
this happens because while OnSelchanged() is executing, the value of my
CNetTreeView object's m_hWnd is NULL. By setting breakpoints I was able to
verify that immediately before OnSelchanged() begins, and immediately after
it ends, m_hWnd is a valid handle to the tree...Mystery!
Your method worked well the first time I tried it. When I tried it a second
time the 'Paste Special' entry was missing on thee 'Edit' menu and it
"Don J" wrote
> Your method worked well the first time I tried it. When I
> tried it a second time the 'Paste Special' entry was missing
> on thee 'Edit' menu and it failed.
Who might you be talking to?
It's best to stick to the original thread so everyone
knows what you're talking about.
...Mystery Read Receipts...
I have this problem on my network where I keep getting read receipts from a
user (from the network) saying "Your message was deleted without being
read". I am getting these receipts everyday at around 4:00am consistently.
I have confirmed that the messages that the receipts are coming from are
being read, I just don't understand why I'm getting them. To add to that,
the client that I am getting the receipts from, is setup to not send read
Any ideas what's going on?
Thanks in advance,
...Update on mystery
The problem first occurs on the ProcessShellCommand statement and if I
comment that out then it fails on the pMainFrame->ShowWindow(SW_MAXIMIZE).
it gives me an unhandled exception in Kernel32.dll. I can compile and run
other mfc apps on this machine and they are fine.
I've had a similar problem like this. I think the secret
is to look inside a "normal" MFC Application's
OnInitInstance trigger, and from there you can see the
code needed to make a form display properly when the
application loads, and what you should likewise do.
BTW --> The InitInstance can be fo...mystery folder appearing
I used Outlook Connector to import my Hotmail and MSN mail accounts into
Outlook 2003 (I use Win XP Pro). After importing the accounts, THREE new mail
folders appeared: one for the Hotmail accout, one for the MSN account, and
another one called 'MSN'. I cannot open this MSN folder, I cant delete it, I
cant close it. If I try to close it, a message pops up saying "The messaging
interface has returned an unknown error. If the problem persists, restart
Outlook." But that does not work. Restarting the computer does not work. I
look in my Outlook folder, and the...IDMXL8.xla
I've seen lots of posts regarding this file missing when the user
trying to save the Excel Spreadsheet.
I've been having the same problem and tried to search for IDM on my
hard drive and found out it may have been causing due to some file
left by 'Filenet Report Manager' Software. There is no mention on
Filenet website for this but would probably check with my support
solution is still the same 'Reset Toolbars'
ProcessShellCommand is calling OnFileNew and in the Document object I am
trying to open an access database. I figured out what is happening. I
downloaded the Update for jet 4.0 Service Pack 8 today and now I can't open
any access databases on my machine. On my laptop I did not download the
service pack and my access databases are just fine. Way to go Microsoft.
You broke what you were supposed to fix. So how do I remove the jet 4.0
service pack 8?
...MSExchangeAL mystery Event ID 8331
"The service threw an unexpected exception which was
caught at f:\titanium\dsa\src\lra\abv_dg\lservagent.cpp
(4511) For more information, click
This error occurs in the Application Log about once per
minute. It started at 3AM about 30 minutes after last
online Exchange defrag.
The system is running Exchange 2003 under SBS 2003
I cannot find a reference to this error ID.
I would suggest calling our support line. A reboot is a temporary work
around but the problem will recur. We are investigating t...Row Height Mystery
It's a mystery to me anyway... Here's my situation:
I have a file with multiple sheets... I selected 5 sheets in this file and
changed the row height to 16.5 ... Later, I checked the height of the row
by moving the cursor to one of the row indicators and clicking when the
cursor turned into a double-headed arrow... It now says 17.25 ... This is
fine except that on one of the 5 sheets, the automatic page break is in a
different spot then the other 4 sheets...
The double headed arrow says the row height is 17.25 but when I check the
row height by selecting the entire row is stil...Mysteries on msnews.
I note that m.p.excel.misc disappeared this morning from
msnews.microsoft.com. It seems to be alive and well on eternal-september
but I restored it to msnews just now and it seems to be receiving the
same posts. What's going on?
Email, with obvious alterations:
Could be something to do with this
When competing...Spy++ mystery
Using the Spy++, I am watching the various WM_PAINT messages
sent to my window. However there are two WM_PAINTS for
every redraw: one marked 'S' as sent the other marked as 'R'
for returned (at least that's what it says in the Spy++ docs).
Does this mean that two WM_PAINT messages are being sent to
my window everytime it needs to be updated? If not, how
does Spy++ end up with the two diferent messages? I was
under the impression that Spy++ was using a windows hook
to look at the messages of a window. How is it able to
get the "return" from a message?
Running Exchange 5.5 SP3. When mail is sent to one of my users from a
particular outside address, it bounces back to the sender with the following
The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was
'firstname.lastname@example.org'.Subject 'test', Account: 'pop.verizonmail.net',
Server:'smtp.verizonmail.net', Protocol: SMTP,
Server Response: '550 Invalid recipient: <email@example.com>', Port:
25, Secure(SSL): No, Server Error: 550, Error Number: 0x800CCC79
When my user trie...A very puzzling mystery
I have an MFC app in VC++ 6 running on a Windows XP machine. Everything was
working fine until I tried running it and it crashed on showing the main
window failing on the Assert that its a valid window. I knew that I didn't
make any changes that would cause it to fail so I took the source code to my
laptop, which also is running Windows XP and it runs fine. I have rebooted,
tried reinstalling Visual Studio. No luck. I cannot run the program on
this computer. It displays the Splash Window and then falls on trying to
display the main window. The only thing that I did was remove Instal...wireless mystery
I have a wireless Linksys router that my fiance uses to
get on internet. For a while everything worked flawlessly
and now for about 10 day she cannot use Outlook. the
first page with her emails opens and then it sits there
for ever and she has to force quit. Her interent browser
continues to work fine. We did not change anything. Any
idea, suggestion would be appreciated.
Thank you, Mirek
Have her close Outlook and find and rename outcmd.dat to .old. (If she is
using Windows 2000 or XP, ensure she enables searching hidden and system
Reopen Outlook and every...Unsolved Mystery
It was march 2002. I had hotmail account. One day I found that somebody
has sent email to my office from my hotmail account. I was shocked. It
has file attachment about airfares. By coincidence, I was in process of
I also started receiving mails on my hotmail account from email address
of none other than my very senior officer of my company (my company is
world's largest insurance company and such things are unthinkable).
Since I had no knowledge of internet and there was no one in my office
who know what internet means, it was shocking puzzle for me. But in
those day...mysterious contacts
when i try to type a contacts name outlook pastes an
old .net passport acccount instead, does anyone know
where i can delete this