A
alandh
A few things - I have a basic background with excel and inputting formulas
from statistics classes and also have done a basic C++ programming course.
I have set up a spreadsheet as a template in excel that I can input raw data
into from my research and get out numbers I need to tell me whats important.
Here are the few things I have run into:
1. The first template I made is only 2 spreadsheets - 1 for the control data
and another that I can make copies of that compares itself to the control
data. The problem is that even the template is giant (~75MB) for some reason
even though I am not using more than 20 rows and no more than 15 columns. The
spreadsheets go down ~65K rows and I've been trying to delete those rows
thinking all those empty cells are the cause of this monster of an empty
excel file. (this also causes our labs computer to lock up for several
minutes when opening/saving/closing). If anybody has any suggestions on how
to remedy this it would be greatly appreciated. (the selecting all and right
click delete thing just kills the program.)
2. In a second ditch effort to fix this I have begun transferring the few
data files I have run though the template (they have ~15 spread sheets) into
new clean files by just copying and pasting the areas that include all of the
data. When I put them into the new files though they reference the old giant
files in their formulas - meaning I can't delete them. Is there anyway to
make it so that when you copy from one spreadsheet to another it doesn't
automatically reference spreadsheets in the old file but instead references a
spreadsheet in the new file with the same name that I make (since I'm copying
them over)?
Thank you for all of your help.
Also if anybody has any suggestions on where I can learn about how to write
and run basic Macros or even just some more advanced formula writing in excel
I would also appreciate it. (I'm really just familiar with using $ to keep
cells straight and being able to select formulas.)
from statistics classes and also have done a basic C++ programming course.
I have set up a spreadsheet as a template in excel that I can input raw data
into from my research and get out numbers I need to tell me whats important.
Here are the few things I have run into:
1. The first template I made is only 2 spreadsheets - 1 for the control data
and another that I can make copies of that compares itself to the control
data. The problem is that even the template is giant (~75MB) for some reason
even though I am not using more than 20 rows and no more than 15 columns. The
spreadsheets go down ~65K rows and I've been trying to delete those rows
thinking all those empty cells are the cause of this monster of an empty
excel file. (this also causes our labs computer to lock up for several
minutes when opening/saving/closing). If anybody has any suggestions on how
to remedy this it would be greatly appreciated. (the selecting all and right
click delete thing just kills the program.)
2. In a second ditch effort to fix this I have begun transferring the few
data files I have run though the template (they have ~15 spread sheets) into
new clean files by just copying and pasting the areas that include all of the
data. When I put them into the new files though they reference the old giant
files in their formulas - meaning I can't delete them. Is there anyway to
make it so that when you copy from one spreadsheet to another it doesn't
automatically reference spreadsheets in the old file but instead references a
spreadsheet in the new file with the same name that I make (since I'm copying
them over)?
Thank you for all of your help.
Also if anybody has any suggestions on where I can learn about how to write
and run basic Macros or even just some more advanced formula writing in excel
I would also appreciate it. (I'm really just familiar with using $ to keep
cells straight and being able to select formulas.)