+ Reply to Thread
Results 1 to 3 of 3

Heavy Excel Sheet

  1. 06-18-2010, 12:12 PM #1
    pansovic
    pansovic is offline
    Forum Contributor
    Join Date
    05-19-2009
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2019
    Posts
    212

    Heavy Excel Sheet

    I have an Excel document that is 546kb that consist of several sheets where the first sheet I use to fill in data and all other sheets are forms that take the data from trhe first sheet.
    Problem is now that the first sheet has become very slowly and freezes my program.
    I work as follow: I create Order in sheet1 and than copy that order to another sheet so that I can create a new order in sheet1. Than later when I want to make the forms I copy a previous order back to Sheet1. So I have the following sheets: sheet1, Order1, Order2, Order3, etc, Form1, Form2, Form3, etc
    Now it seems that when I copy an old Order back to Sheet1 it copies over the info already in sheet1 instead that it replaces it. So after some time it becomes lots of orders copied above eachother. I had a logo and indeed I noticed that the logo was never replaced but had some 100 logos on sheet1. I deleted the logo and all went smooth but now again I have the same trouble.
    Any clever answer?
    Reply With QuoteRegister To Reply
  2. 06-18-2010, 12:17 PM #2
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Heavy Excel Sheet

    Instead of pasting it back, Paste Special > Values. Your objects (logo) won't be included if you do that. Paste Special > Formulas will also work if you want to keep formulas the way they are. Does that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  3. 06-18-2010, 12:52 PM #3
    pansovic
    pansovic is offline
    Forum Contributor
    Join Date
    05-19-2009
    Location
    Santiago, Chile
    MS-Off Ver
    Excel 2019
    Posts
    212

    Re: Heavy Excel Sheet

    Quote Originally Posted by ChemistB View Post
    Instead of pasting it back, Paste Special > Values. Your objects (logo) won't be included if you do that. Paste Special > Formulas will also work if you want to keep formulas the way they are. Does that help?
    Not really, I still have the heavy slowly sheet. Maybe with this it doesn't add up nad indeed replaces but I don't know

    Now I found something strange and maybe it is related with my problem. To fill in a date I use a popup calendar and than click the right date. Point is that I used to work with one model of Calendar that calls "UserForm2" and now work with another model that calls "frmCalendar". When I made the change I changed in Visual basic (alt F11) to "frmCalendar.show". Though the strange thing is now that in Sheet1 and some Order sheets appears "frmCalendar" model though in 5 Order sheets (total 7) appears the "UserForm2" model. When I open in these order sheets the VB (alt F11) it does is written "frmCalendar.show".
    Maybe here my document get confused and requires lots of processing data. Though how to correct this as that in VB all appears with "frmCalendar"?

    Now I receive the following error message:
    "Has produced the error '6' in time of execution: Overflow"
    When I click on Debug than is marked in yellow: "If Target.Cells.Count > 1 Then.

    Anybody can help me out?
    Last edited by pansovic; 06-23-2010 at 03:09 PM. Reason: Now get error message
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1