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.
...Using Workflow to render and email a report
Hope someone can help me. My requirement is to use workflow to render a
report and email it.
I am indebted to Guenter for
Using this as a basis for constructing a solution - and I have it running !
But, only by hardcoding network credentials with which to call rs.render
Workflow runs in Network Service (CRM SYSTEM user) context so can't use
default credentials to call it
And I don't want to use report stored credentials
I can get user name/guid into the workflow module to impersonate using
callerid for the crm service...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 <email@example.com> 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 ...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
-- ...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...=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" <firstname.lastname@example.org> 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" <email@example.com> 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...data look up and return values across a row
I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
to cross reference with another larger spreadsheet, which we'll call
'spreadsheet B'. I'd like to remove everything from B that isn't on A. Is
there an easy way of doing that?
Chip Pearson has lots of info about working with duplicates at:
> I have a list in one spreadsheet, we'll call it 'spreadsheet A' that I need
> to cross reference with another larger spreadsheet, which we'll call
> ...downloading excel from Office home and Student
I bough Office Home and Student how do I download Excel
"Downloading Excel" <Downloading Excel@discussions.microsoft.com> wrote in
> I bough Office Home and Student how do I download Excel
Office Home and Student HAS Excel. You need to clarify your question.
...Excel "Micorosft Query" from Access (Too Many Parameters)
• In Access I can enter a dynamic parameter that is read into a query
(sql statement) - - the parameter is usually in a form
• I then utilize the Data tab in Excel – from other sources “Microsoft Query”
• If I have a hard coded parameter it pulls data from Access just fine, but
if I have a dynamic parameter it refuses and says “too many
• My question is – is there a work around?
...Excel 2000 #9
Is there a way to change the date format in footers and headers.?.these two
items do not seem to pick up the formatting specified for the individual
Excel in any version uses the Short Date format from Windows Regional settings
You can make some minor changes in Regional settings but not too much.
How about a macro to add the date in any format you choose?
.PageSetup.CenterFooter = Format(Date, "dddd, mmmm-dd-yyyy")
Gord Dibben MS Excel MVP
On Tue, 5 Feb 2008...