Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loss of data in very large calculations (vba in excell)
I am making very large calculations (25 sheets of data) with vba in excell
and at some point I am losing data. I am pretty sure that the (calculation) programming is correct. I am thinking that is has something to do with the available memory? Who knows? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loss of data in very large calculations (vba in excell)
If you run out of memeory, you will get a warning along those lines.
Neither Excel nor VBA forgets data, as a rule, so the first suspect would be your code. Try to narrow it down and post back with more details. Otherwise not much anyone can say. NickHK "RH" ... I am making very large calculations (25 sheets of data) with vba in excell and at some point I am losing data. I am pretty sure that the (calculation) programming is correct. I am thinking that is has something to do with the available memory? Who knows? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loss of data in very large calculations (vba in excell)
Thanks, I dont get a warning for memory. The reason why I stopped suspecting
my code is that the code is running the same sort of calculation on every sheet. (data sorting and other basiccaly simple calculations). It runs through all the sheets. At sheet nr 12 I start to lose data. And in the sheets after that but not before that. If I run the code for a single sheet, for a "bad"" sheet, after a restart it seems to work correctly, hence I thought memory....... that is what I can think of for now.. "NickHK" wrote: If you run out of memeory, you will get a warning along those lines. Neither Excel nor VBA forgets data, as a rule, so the first suspect would be your code. Try to narrow it down and post back with more details. Otherwise not much anyone can say. NickHK "RH" ... I am making very large calculations (25 sheets of data) with vba in excell and at some point I am losing data. I am pretty sure that the (calculation) programming is correct. I am thinking that is has something to do with the available memory? Who knows? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loss of data in very large calculations (vba in excell)
This is a long shot, but apt, make certain you're using Longs, not
Integers which tap out around 32,600. The code might be reseting an Integer to 0. RH wrote: I am making very large calculations (25 sheets of data) with vba in excell and at some point I am losing data. I am pretty sure that the (calculation) programming is correct. I am thinking that is has something to do with the available memory? Who knows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hardship letter explaining devastating loss property loss financi | Excel Discussion (Misc queries) | |||
loss of speed with excell 2007 | Excel Discussion (Misc queries) | |||
Excell Calculations | Excel Discussion (Misc queries) | |||
Dealing with a large table and multiple calculations | Excel Programming | |||
calculations in large data set and in pivot table | Excel Programming |