RE: Excel to Excel, Cut & Paste, 1 cell, text, multiplies file siz

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: PboB (PboB_at_discussions.microsoft.com)
Date: 03/03/05 

Date: Thu, 3 Mar 2005 10:07:04 -0800

Thanks for replying
System is Windows XP, Excel is Office 2000, originally the 1MB file was
networked but in trying to resolve this I copied it to my system and worked
locally. Haven’t run the systems utilities in a while, however, there are no
problems at all until I open the two files and copy a cell from the smaller
file to the larger file. I am thinking it is something to do with merged
cells or formatting. I am only inputting text to <20 cells so there is no
accounting for going from 1MB to 10MB.
In the main file I ended up highlighting all unused cells to the right my
data and deleting them, same for below, Did a global change to font, size and
position and the file was back to normal. Again the strange thing is if I
copy from the first file and enter on the formula bar for the second its
fine, but if I click the cell and do ctrl-v to paste it is all over. Lastly
because I wasn’t sure of the version of the smaller file I did a save as and
re opened and got the same results…it’s a good one J

"CyberTaz" wrote:

> You don't mention what ver. of Excel or Windows, so it is more difficult to
> guess. It sounds like more of an equipment problem, though.
>
> What is the condition of your hard drive in terms of fragmentation?
>
> Are both files on the same drive? Is that drive local or network?
>
> More info please |:>)
>
> "PboB" wrote:
>
> > Hello
> > I have two Excel files, the main file is ~1MB and the other is 43KB. When I
> > Cut and Paste between the two the system takes >2 minutes to complete the C&P
> > operation. After several C&P the delay is in the 10+ min range. If I save and
> > exit the file the master is now over 10MB. Each operation is no more then 1
> > or 2 cells at a time, the cells are text only. If I cut from the cell but
> > enter on the formula bar, 1 cell at a time, I have no problem. I do this
> > operation all the time and have never had this problem before. I am assuming
> > it is from the smaller Excel file but cannot find a problem with it.
> > Thanks
> >

Relevant Pages

  • Cell Values do not recalculate unless you press f9
    ... When using excel 2003 i have cells where the value is calculated by a ... Any ideas what is causing and how to resolve? ...
    (microsoft.public.excel)
  • Re: what is inconsistent formula in region in excel?
    ... That means formulas in cells in the same region of the sheet are different. ... It's just Excel trying to be helpful. ... How to resolve when it occurs? ...
    (microsoft.public.excel.misc)
  • Re: Look out you ubly ladies<==Proof that Prowar Alex is a fuckwit.
    ... On transhumanism: I don't think we are smart enough to build a strong ... flagellum were attached to red blood cells. ... produce nano-computers or spin out useful molecules or molecular ... world wide network of nodes and their interconnections. ...
    (soc.politics)
  • Re: Best practice to store/manipulate Excel spreadsheet cells
    ... and would adapt well to an irregular floor plan. ... is likely to be a better way of getting a "live" floor plan than Excel. ... part of an event managment database. ... 72 cells at top and 91 cells at the bottom with a height of 44 cells. ...
    (microsoft.public.access.formscoding)
  • All words and Symbols of keybord should be added to Auto Shapes
    ... Suggestions are both for Word and Excel where applicable. ... Transpose should have an extra facility to transpose the selected cells ... display begins in the second line and therefore we cannot see row name A, B, ... And more in a single selection at a time, then there will be no problem. ...
    (microsoft.public.excel.misc)