Microsoft Excel Populated by

Posted on 2006-03-30
Last Modified: 2010-04-23
I have an application that has for about 2 years been using a MS. Excel spreadsheet as its reporting tool. It does the sql query and then it posts the results into an Excel Spreadsheet. It does do some formatting and to date it has been running fine. ABout 2 days ago the two ladies who use it began to notice that it was slowing down and now a 30 second report is taking2-3 minutes. I have defragged and done a disk cleanup. This does not seem to help. I have also done a spyware check just on the outside chance that this could be an issue. If anyone has any ideas please let me know.  Thanks in advance.

Question by:dabryantIT
    LVL 14

    Accepted Solution

    Maybe everybody liked the tool so much, and now your database has began to fill up?

    Author Comment

    The spreadsheet is manipulated and then deleted. It actually creates a new spreadsheet each time it generates. The database is SQL so I wouldnt think that would be the issue plus wouldn't that be felt by everyone?

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
    Introduction When many people think of the WebBrowser ( control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now