Issues with Integrating Multiple Spreadsheets for Reports or Queries?

We are keen to discuss and help with issues arising when needing to
query, or produce reports using multiple Excel spreadsheets (Multiple
Excel Spreadsheet Integration issues):

Issues like:
- We can=92t easily compare a choice of values in one spreadsheet with a
choice in another worksheet
- So we cannot easily answer the question =93what do all these rows have
in common with those rows=94

Because:
- We have to do a weekly report integrating multiple Project Plans,
Financial Analyses =85
- We spend tons of time cutting and pasting, sorting and merging =96 the
same process repeated every week =85
- We want to do =91reports=92 that need to draw data from several
spreadsheets that are always changing, owned by someone else, the data
is inconsistent and =91dirty=92 =85
- We want to ask quite sophisticated questions that run across many
spreadsheets, but we don=92t know in advance what we want to ask - Our
needs change dynamically as we analyse the data.

Please note that although we offer a product for Multi-Spreadsheet
Integration - we are here to help if we can, discuss and problem solve
as everyone else is doing here on their own dime - NOT merely to sell
product.

Ian Goldsmid
Multi Excel Spreadsheet Integration:
http://www.semanticbusinessintelligence.com/excel.html
http://www.semanticbusinessintelligence.com/videos.html
0
8/8/2008 12:16:59 AM
excel 39879 articles. 2 followers. Follow

0 Replies
892 Views

Similar Articles

[PageSpeed] 50

Reply:

Similar Artilces:

Format issues
I have created a template in word which I call through a VB script from excel. The excel data is populated in the word every time I run this script. Everything works fine and the data get populated. I have a header in the template which is represents one of the fields in the excel sheet. The header shows the correct linked value for the first 10 pages but then on shows the variable name instead of the value. I have no idea why it does that? can someone help The code is as follows: For iCurrentRow = 1 To iLastRow If ActiveSheet.Range("B" & iCurrentRow...

Extra cover page when report exported to PDF
I am using SQL Reporting Services for SQL Server 2005. I have a report that uses a page header as a cover page. When the report renders in the browser, the cover page prints once (as expected) and then the data begins on page two. When the report is exported to a PDF, I get two cover pages. The first cover page does not print the report items fields so I can identify it as the "extra" page. The second cover page is identical to the cover page that renders in the browser. Does anyone have any ideas what I can take a look at? figure out why your page is too wide? that's th...

event ID 9153 Microsoft Exchange System Attendant reported an erro
Guys I am receiving 9153, Microsoft Exchange System Attendant reported an error '0xc00706fc', when setting DS notification source MSExchangeSA I am not in mixed mode Exchange envorinmed, Native mode clustered exc 2003 server, active passive. we did not have any domain controller demoded, whic was primary internal DNS for the exchange server. our smtp q is clear, Exchange boxes are able to locate the DNS and GC servers, MsexchangeDSAaccess is showing all the servers are succesfully discovered. We are receiving 8213 along with this error, MSExchangeFBPublish, "System At...

RMS should be able to handle multiple serial numbers easier.
When you have to enter many serial numbers , either to take itmes into stock , transfer stock from store to store or even sell, it is not very fast . I think simply if when you scan a serial the code just places a tab or enter so the cursor will automatically move to the next line . In this way the scanning process will be much much faster . ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this ...

How do you copy multiple pictures to a publication?
You don't copy them, you insert them. -- JoAnn Paules MVP Microsoft [Publisher] "sidneyl" <sidneyl@discussions.microsoft.com> wrote in message news:7CE65722-C4F9-49D5-92CF-910D8BB4A67F@microsoft.com... > I never tried copying (inserting for Jo) multiple pictures into a Publication before but this seems to work in Pub 2000. Open an existing or new Publisher file; go to the folder with the pictures and gather as many files as you want; do a Edit, Copy; go to the Publisher file; do a Paste. You will now need to arrange the pictures to your liking. -- Do...

Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange 2003 on a new domain. This was performed with the exmerge utility in a 2 step process. Now there are 2 issues with Oulook: 1) When a user types a recipient name into the address field, the name autocompletes as normal. But when the mail is sent, a message returns saying it is undeliverable. However, if the user goes into the Contacts folder and from there selects the same user to send a message to, it is successful. 2) If a user shares a calendar, specifying the user with whom to share and the level of permissions, all users in ...

multiple link criteria in sql statement
Can you help? The scenario: Click on ID # in a subform and the form opens with the information tied to the ID, by the Item Desc. What I want to know is........how do you add to the criteria? I'd like to use Item Desc AND Customer in the "stLinkCriteria", but not sure how to code it. Private Sub ID_Click() On Error GoTo Err_ID_Click Dim stDocName, stLinkCriteria As String stLinkCriteria = "[Item Desc]='" & [Item Desc] & "' " stDocName = "Face Sheet to be reviewed" DoCmd.OpenForm stDocName, , , st...

Integration Manager XML Adapter?
Where can I find the XML adapter for the Integration Manager? We just upgraded our Integration Manager and GP to V10 and we cannot find the XML adapter on the new IM. Please let me know Thanks, If you're looking for the XML Source adapter, I think you'll find it with SP 2 -- Leslie Vail, CPA, MCT, MVP MCBSP-Application for Microsoft Dynamics GP MCBSP-Installation and Configuration for Microsoft Dynamics GP cell: 972-814-8550 fax: 972-692-7472 "Sean" wrote: > Where can I find the XML adapter for the Integration Manager? We just > upgraded our Integration...

Taskbar issue
Hello All I'm hoping someone can help me with this long-standing problem with both XP and Vista on separate laptops and every computer I've had (except I think Win98). I'm thinking there may be no solution, but what it's worth a try. With both of my machines, I have the taskbar (as well as other toolbars) set out to maximum size - typically half the screen - and to auto hide. (This makes a great program and file launcher) The issue is that the operating system decides it wants open the taskbar on its own from time to time on its own. Various things prompt this, ma...

DST issue
I entered the catalog item: <Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" /> and confirmed that the device has the registry key: HKLM\Software\Microsoft\Clock\AutoDST = 1 But the device still does not automatically adjust for DST. I set the timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one minute...and the time changed to 2:00AM instead of 3:00AM. What am I missing? Thanks. which OS version are you using? have you updated it with the relevant qfes which deal with the changing in DST starting day? -...

multiple instance of CRM on domain
We have a situation where two divisions want seperate instances of CRM. It is important to note, each division has it's own domain. While I know we can manage that, my question concerns the exchange router. Since the email for both divisions come through the same exchange server (and through a third domain), my assumption is there would only be one exchange router. Has anyone done this before and what are the potential issues I may need to address to make this work? This will probably answer your question (or some parts of it anyway): http://blogs.msdn.com/crm/archive/2006/10/0...

Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can recieve it using Outlook. There error says that Outlook was unable to access the SMTP server. I cannot access my email at HOME through the web email. What I can do is send/recieve email using Outlook Express AND I can access my email through my web email client outside my home. My ISP (SBC) says its not them and I'm somewhat inclined to agree with them? They say I could have a corrupted kernel32.dll file. I have turned off my Norton, deleted my account and set up a new one and re-installed XP professiona...

naming cells in multiple worksheets #2
Frank, Thanks, Crai -- cparson ----------------------------------------------------------------------- cparsons's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1286 View this thread: http://www.excelforum.com/showthread.php?threadid=26681 ...

Multiple Promotional Credit Card Rates
Is there a way in Money 2004 to have more than one introductory rate? My wife has transferred so balances to her credit card account using balance transfer checks over time and the rates range from 2.90 to 6.90% for the life of the transfer and since the credit card company uses the payments that we send in to the lower interest rate, just would like to know how the finance charges are being applied to each individual rate, if that is possible to do on Money 2004 that is Thank you Not possible AFAIK. -- Regards Bob Peel, Microsoft MVP - Money For UK tips & fixes see http://su...

MSX 5.5 isinteg report
Recently the private IS on our MSX 5.5 server (SP4) went over the size limit and crashed. One admin ran an offline defrag and was able to get the IS service going. We then had users clear out about 4GB of space, and we defragged again. Priv.edb is now down to about 12GB. Since the crash, there have been a variety of random problems with variuos users' email. I ran isinteg -pri - test, and the report gave over 1,000 WARNINGS, but no ERRORS. We are wondering if we should run isinteg with the -fix option, but there is not a lot of good documentation on it. Any suggestions would be h...

Extender Install Issues
GP 8.0 Extender install - I'm encountering the following: *Login to GP brings up screen: "Great Plains Extender needs to finish installing. This may take a few minutes". It has an OK button and clicking on this gets you into GP but it comes up everytime. How can we stop this from popping up all the time. *When creating a new Extender Window and I get select the Form, I get the following error: "A remove range operation on table 'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or function zDP_EXT40101L_1 has too many arguments spec...

Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to be able to use some of the tables and subtables as a sort of checklist for the audits. The table/subtable structure is as follows: Topic -->Subtopic -->ProgramArea -->ProgramRequirement I decided to create a report that will output that data. However, the report is only outputting information if there are ProgramRequirements already entered for a given ProgramArea. Is there a way to get it to output the ProgramArea and ProgramRequirement even if blank? Or am I going about th...

Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are unable to send documents to PDF from GP - the PDF option remains grayed out. We have folowed the KB articles that are available, no success. Do we need to install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe 9? Thank you for any assistance.. Hi Susan, I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0 It is working succesfully. -- Geoff James "Susan" wrote: > We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...

Report vanished in Money 2000-WHY??
I have been using Money 2000 and print the MONTHLY CASH FLOW report every month with out problems...until now. Now, it doesn't show up....the information isn't there, but is available for every other report. I have recently set up another money file for a seperate checking account for my son to learn on....and that is all stored under a seperate Money file and the report will open for his accounts... Any suggestions to regain access to this report would be great appreciated. Thanks. DeAnna In microsoft.public.money, SugarAndSpiceAccessories.Com wrote: >I have been us...

Issue with formula is Pivot table
I have the following formula in a pivot table: =IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) First to the issues that I am experiencing. First, the formula wa originally added as the one below but then updated to the formula abov to correctly reflect what I was trying to accomplish. =IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) This issue is the original formula appears in the very first cell o the pivot table and then periodically through out the column. So, yo see ...

view in XP from single window to multiple
In XP all of the open windows use to appear in the bar at the bottom. Now Excel just displays as one item on the bar below and I must use Excel's "Windows" menu item to switch b/t them. How do I switch it back? In Excel: Tools | Options | View tab | Windows in Taskbar Regards Trevor "kenw100@yahoo.com" <anonymous@discussions.microsoft.com> wrote in message news:3bb201c48fa2$098d0fd0$a601280a@phx.gbl... > In XP all of the open windows use to appear in the bar at > the bottom. Now Excel just displays as one item on the > bar below and I must u...

Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a webpage it returns an error stating that the the "item could not be created". Outlook 2000/Windows 2000 ...

Free Experian Credit Report #2
The link to sign up for Experian doesn't work for me. I get a "the page cannot be displayed" I'm useing M2005 Premium and running XP with SP2. Has anyone else been able to sign up for this free service? Zach In microsoft.public.money, Zach Rose wrote: >The link to sign up for Experian doesn't work for me. I get a "the page >cannot be displayed" I'm useing M2005 Premium and running XP with SP2. Has >anyone else been able to sign up for this free service? The link from Tools->FinancialServices clicking on Get Started brings up a w...

Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users, Starting over the last two weeks (possibly after an update on the Exchange server), all of my users are starting to encounter the same issue when using Outlook Web Access (using IE6 on XP Pro systems). We have images in our signature block, and now when someone replies using Webmail to an e-mail originally sent via Outlook 2003, a login prompt appears for each image in the e-mail. Every time you cancel the login box, a red x image box appears, until all of the images that should be there are represented by the red x boxes. For the record, this has w...

page # on MRP exception report
Anybody know how to get page numbers on the MRP Exception Report? I tried adding the page number field but all it prints is a 0. The existing page number field that prints in the RH is called Page No. but i can't find it in the Tools to select and I dont think you can copy and paste a field from the report. The only selection is from Globals and that is "Page Number". Doesnt seem to work the same. Any help is appreciated. Hi Wes, This is an issue that we are addressing in the next release (8.5) that is due out later this year. In the mean time, I was able to get the page...