| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linked cells slowing me down?
I have a small workbook that I'm trying to cheat into a database. I have a
simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
On 31 Jul, 22:56, Elizabeth
wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
It's only about 45 rows, but there are three values that do this on four
sheets. "Matthew" wrote: On 31 Jul, 22:56, Elizabeth wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
On 31 Jul, 23:08, Elizabeth
wrote: It's only about 45 rows, but there are three values that do this on four sheets. "Matthew" wrote: On 31 Jul, 22:56, Elizabeth wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew Elizabeth, No, this should not be slowing you down, what is the purpose of the work book? does it have loads of pictures/objects Matthew |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
It is basically a checklist. There aren't any graphics or objects - just
those linked cells. I had two dropdown lists at one point, but took those out to see if they were the problem. Is there any diagnostic tool that can help me figure out if it's corrupted somewhere? "Matthew" wrote: On 31 Jul, 23:08, Elizabeth wrote: It's only about 45 rows, but there are three values that do this on four sheets. "Matthew" wrote: On 31 Jul, 22:56, Elizabeth wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew Elizabeth, No, this should not be slowing you down, what is the purpose of the work book? does it have loads of pictures/objects Matthew |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
Could be your TIF folder is very full.
Empty it and your WindowsTemp folder. And have a look at Charles Williams' site for more on memory. http://www.decisionmodels.com/memlimits.htm Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 15:28:02 -0700, Elizabeth wrote: It is basically a checklist. There aren't any graphics or objects - just those linked cells. I had two dropdown lists at one point, but took those out to see if they were the problem. Is there any diagnostic tool that can help me figure out if it's corrupted somewhere? "Matthew" wrote: On 31 Jul, 23:08, Elizabeth wrote: It's only about 45 rows, but there are three values that do this on four sheets. "Matthew" wrote: On 31 Jul, 22:56, Elizabeth wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew Elizabeth, No, this should not be slowing you down, what is the purpose of the work book? does it have loads of pictures/objects Matthew |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
On 31 Jul, 23:28, Elizabeth
wrote: It is basically a checklist. There aren't any graphics or objects - just those linked cells. I had two dropdown lists at one point, but took those out to see if they were the problem. Is there any diagnostic tool that can help me figure out if it's corrupted somewhere? "Matthew" wrote: On 31 Jul, 23:08, Elizabeth wrote: It's only about 45 rows, but there are three values that do this on four sheets. "Matthew" wrote: On 31 Jul, 22:56, Elizabeth wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew Elizabeth, No, this should not be slowing you down, what is the purpose of the work book? does it have loads of pictures/objects Matthew Elizabeth, e-mail me the work book. harrison54 at btopenworld dot com change the various bits to @ and . Matthew |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Linked cells slowing me down?
You may need both workbooks - remember the one in question is nothing but a
bunch of links. "Matthew" wrote: On 31 Jul, 23:28, Elizabeth wrote: It is basically a checklist. There aren't any graphics or objects - just those linked cells. I had two dropdown lists at one point, but took those out to see if they were the problem. Is there any diagnostic tool that can help me figure out if it's corrupted somewhere? "Matthew" wrote: On 31 Jul, 23:08, Elizabeth wrote: It's only about 45 rows, but there are three values that do this on four sheets. "Matthew" wrote: On 31 Jul, 22:56, Elizabeth wrote: I have a small workbook that I'm trying to cheat into a database. I have a simple formula (=B2). That I use to replicate a single entry down a full column and I do this in several places in each sheet. It works great!! The problem is that the workbook is only 270 KB but has gotten extremely slugglish. Is all of the linking slowing me down? Thanks for your help. Elizabeth, Do you mean down all 65,000 odd rows ? Matthew Elizabeth, No, this should not be slowing you down, what is the purpose of the work book? does it have loads of pictures/objects Matthew Elizabeth, e-mail me the work book. harrison54 at btopenworld dot com change the various bits to @ and . Matthew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2003 slowing down | Excel Discussion (Misc queries) | |||
| Excel slowing down during usage | Excel Discussion (Misc queries) | |||
| View zoom slowing opening of the file | Excel Discussion (Misc queries) | |||
| Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
| slowing down | Excel Discussion (Misc queries) | |||
Linear Mode
