Can anyone reproduce this bug?
I use Money 2007 Deluxe. It is fully updated.
I've noticed that if the "This series will end at some point in time" check
box is checked, the "date of final transaction" will sometimes automatically
To reproduce the bug, the "next payment date" must be on the "28th" which
will make the "date of final transaction" on a date of the "28th." Then
click in the box for "date of final transaction." Finally, click in any
other box. If you keep repeating this process, the date will chance upto 6
times before n...Excel users! Do-It-Yourself Dashboards, Reports, Guided Analytics and Business Presentations!
SiSense is pleased to announce the beta release of its first product Prism -
a Powerful, innovative Do-It-Yourself productivity software for building,
sharing and using business intelligence applications that solve common,
information driven business problems.
* Build informative Dashboards, Reports, Scorecards and Guided Analytics
solutions in one environment, over one or multiple data sources like Excel,
Relational Databases, OLAP cubes and more...
* Perform powerful multidimensional analysis over any data source using an
extensive collection of filters and multidimensio...Excel security update causes system to label Excel files as damage
After the recent installation of the KB918419 Security Update for Excel
update on our network, problems occurred with a number of reports that we run
regularly. These reports are coded in Perl and generate formatted Excel
spreadsheets from a database. On opening the spreadsheets Excel claims the
file is "damaged" and must be repaired. Repair seems to involve the removal
of all formatting.
Removal of the security update from our system caused the problem to stop,
but this is a temporary solution.
Removal of the code from the reports that sets the column size also solves
the pro...shared templates in Excel
How do I share a template folder between 2 computers on a
local peer-to-peer network? In Word, I can specify the
template location. How does it work in Excel?
I have Windows XP. Thanks.
...In an excel chart I want missing data to be ignored
I have several graphs I want to generate from a table of data. Some of the
data is missing for certain parameters. Excel will not join points that are
not part of a continuous set of data
date Na conc. Cl conc
1/3/08 13 6
1/6/08 4 3
If the cell is truly empty and the line drops to zero select the chart
Tools > Options > Chart > Plot empty cells as...
If the cell actually contain conditional fo...Excel on thin client
We are experiencing a problem on a thin client box with
the RDP client. When we highlight a group of cells and try
to drag them we lose control and the selected range
expands without being able to stop it apparantly until the
buffer empties. There is a known issue with a thin client
box and Citrix ICA but is there also one with RCP.
...All my icons look the same (except IE8 and the recycle bin)
i cant open any windows...when i click on them the open with window pops up
and wants me to pick wat i want to open it with...i can only get on the
internet in safe mode with networking. and when i try to open...for example
paint it says invalid bitmap, or its format is not currently supported and
other windows wont even open.
got any ideas on how i can fix this??
On Sun, 30 May 2010 06:54:01 -0700, xxkoreanxx wrote in message
> i cant open any windows...when i click on them the open with window pops up
> a...Excel 2000 Problem
I have a client running some excel documents on Excel2000 on a Win98
The files are 2mb+ with lots of links.
"Sometimes" when opening the following error comes up :
EXCEL caused an invalid page fault in
module EXCEL.EXE at 0167:300a22ae.
EAX=00030030 CS=0167 EIP=300a22ae EFLGS=00010206
EBX=00000000 SS=016f ESP=0062a4fc EBP=0062a56c
ECX=021c0080 DS=016f ESI=021f00bc FS=12ef
EDX=00000010 ES=016f EDI=0062ce70 GS=0000
Bytes at CS:EIP:
8b 44 08 0c 89 45 dc 0f bf 07 47 89 45 e0 47 0f
00000000 0000201e 0062ae50 82a7fad8 3069f9c0 00000000 0062a524 0062a53...Export Filtered Form Data To Excel
Here's one that's been bugging me for about a week now...
I have a form that allows users to filter records, simple enough. But I want
to give them the option to export the filtered records to Excel. I don't
want to use the docmd.outputTo due to it won't filter the records, it puts
all of the records in the file. I've looked around and found some code
(actually that I'm already using), but the problem is that it outputs
EVERYTHING on the form. My goal is to output only the fields that are on the
I found another bit of code (following) that does what I need...Exporting to Excel 2007 format from asp.net application
I am trying to change my excel export format from .xls to .xlsx but till now
I dont have any luck for this. I also tried changing content type and
extension to .xlsx with no luck.
Also when opening with .xls in Excel 2007 it gives me format error. I am
sending plain HTML with content type changed to achive this.
I want this functionality to be migrated to .xlsx format with minor changes
Please help me out on this.
...Problem with Excel 2000 Pivot Table in Excel 97
Greetings! I am attempting to use an Excel 2000 (E2K) worksheet with a pivot
table in Excel 97 (E97); however, in E97 the drop down arrows for the row and
column are missing. I'm clueless on what could be causing this.
If I'm not mistaken E2K and E97 use the same file format. Are their any
limitations on the use of pivot tables in E97 that do not apply in E2K?
I certainly would appreciate any help anyone could offer.
...How do I open a com port using Excel visual basic
Has anybody got any code that would help me
...Looking for feedback
Hey everyone just started my own business doing consulting / training for Microsoft Outlook please check out my site www.outlookchallenged.com and provide any suggestions / feedback please. Any advice is good advice at this point.
Br Sense <firstname.lastname@example.org> wrote:
> Hey everyone just started my own business doing consulting / training
> for Microsoft Outlook please check out my site
> www.outlookchallenged.com and provide any suggestions / feedback
> please. Any advice is good advice at this point.
The best advice I have to offer ...How can i create custom label sizes in Publisher 2000?
We'd like to use Publisher 2000 to print package labels, 6 per page, 2 7/8"x5
We hope it will be less difficult to lay out than in Word.
See the following links:
Microsoft Publisher MVP
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Mumm's Sprouting Seeds" <Mumm's Sprouting Seeds@discussi...visual basic in excel -
Hi - I would like to Copy/Paste an area dependant on how many rows there are
on a spreadsheet. I was thinking of using something like the below:
X = COUNT("D:D")
Range("A1:A" & X).Select
Range("D1:D" & X).Select
Range("E4:E" & X).Select
Setting X as the COUNT of Column D, then adding '&' X to the Range to set
the length of the Copy/Paste.
I haven't gotten it to work. Any advice?
X = Application.COUNT("D:D")
you might want COUNTA if there is text in the column
-- ...Windows XP 64 - Blue Screen of Death
So I have set Event logging with small memory dump in XP 64 bit, in the
System Properties/Startup & Recovery, in order to diagnose a BSOD in
Unfortunately, when my PC blue screens, no event is written, and no minidump
appears in the minidump folder.
I have tried this both with letting the PC reboot automatically, and without.
How do I ensure a minidump appears, and a system log entry is written?
PS Crossposted purposely in XP 64 bit discussion, and accidentally in XP
Did this start happenin...GPR_PROPAGATION errors filling up log
I am running MOSS2007 (patched to Oct 2009 cummulative roll-up) as a small
farm on a 32-bit Win 2008 SP2 with a SQL Server 2008 on a 64-bit Win 2008 SP2.
The following errors appear regularly in my logs. Should I be alarmed? How
can I configure my system to avoid these errors?
05/07/2010 12:33:40.68 OWSTIMER.EXE (0x185C)
0x0398 Windows SharePoint Services E-Mail
6871 Information The Incoming E-Mail service has completed a batch. The
elapsed time was 00:00:00. The service processed 0 message(s) in total.
0...Excel Toolbars in Word
I have created my own customised toolbar for word. I want to get rid o
the menu which has: File, View, Tools, etc. I know this can be done i
excel but can it be done in word
Message posted from http://www.ExcelForum.com
This is an Excel group not Word!
But as it happens, it works the same way, the commandbar is just called Menu
Bar not Worksheet Menu Bar
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"ianripping >" <<...export data from excel to adobe
If you have 2007, Microsoft has a free add-in that will add the ability to
print to a file in .pdf format that works across all Office 2007
If you don't have 2007, then one of the easiest to use .pdf file creators is
probably PDFCreator from SourceForge:
http://sourceforge.net/projects/pdfcreator/ it installs as a virtual printer
on your system and when you wish to create a .pdf file you simply print to
that virtual printer. Instead of a sheet of paper, y...Looking for CRM Solution
Does anyone use, or has anyone encountered, a CRM based solution used for
residentail, multifamily property management?
On Apr 28, 12:55=A0pm, MrB <M...@discussions.microsoft.com> wrote:
> Does anyone use, or has anyone encountered, a CRM based solution used for
> residentail, multifamily property management?
The beauty of Microsoft CRM is that it can be customized for any
business in any industry. It's ability to be customized using front-
end tools (not within code) is , as far as I know, unparalleled by any
other software package. You have the ability to create new entiti...How to delete of archive log files! Emergency!
My Windows 2003 Exchange server went down this morning. The reason was HD
space. When looking at the HD I found a total of 39 GB used by Exxxx.log
files in the First Storage Group. There are log files as old as 9/28/2004.
There are a total of 8153 log file and each one takes 5 MB.
My question is how can I delete some, a range or all of these files?
If you are able to help please advise and reply to this e-mail.
Thank you in advance for your help!
On Thu, 21 Jul 2005 10:21:05 -0700, DMI
>My Windows 2003 Exchange server went down this ...=COUNTA() with multiple look-up
I would like to count the number of items that have a value "AAA" in
column A and an amount >0 in column B.
As I am not quite sure how to incorporate two look-ups in a counta
formula I was wondering if anyone can give me the formula?
Try something like this:
or....if there may be some text cells in B1:B100 interspersed with the numbers
Is that something you can work with?
&...Excel : Cursor
Nearly finished the project I have been working on so will soon sto
Is there any way of hiding/removing, the cursor box off a particula
sheet? So the user would have to use the hyperlink icon.
Message posted from http://www.ExcelForum.com
you can try protecting/locking the cells. would that work for you? you can do that by going to tools, protection, protect sheet.
"ajw150 >" wrote:
> Nearly finished the project I have been working on so will soon stop
> Is there any way of hiding/removing, the ...can I edit a picture to look faded?
I want to edit my picture to be faded so I can use it as background with text
"deborahm" <email@example.com> wrote in message
> I want to edit my picture to be faded so I can use it as background with
> over it.
In Publisher you can do it one of two ways. For both ways start by
inserting the picture.
Method 1, right click on picture and select Format Picture, click on picture
tab, then click on the dropdown for Color under Image Control and select
wash...Big mouse pointer size in Excel
Any body know how to change the mouse pointer size (the +
pointer) in Excel ? I don't know why in one client's PC,
its mouse pointer is bigger than normal, is it some kind
of installation problem?
Go to Start SEttings Control Panel SEttings Mouse and you should be able to do
some changes there
"KL" <firstname.lastname@example.org> wrote in message
: Any body know how to change the mouse pointer size (the +
: pointer) in Excel ? I don't know why in one client's PC,
: its mouse pointer is bigge...