I ran a test on a sample file I have with 74 entries in the Name field. The test uses a
for loop set to 100 itinerations. Each loop uses a formulafill to first set all the cells to “” and then follows by setting them back to their original values using the contents of an array first created with an
arraybuild(. Here is the code I used:
local theContents, runtime
startdatabasechange "ALLRECORDS","Reload Names"
noshow/showpage/endnoshow lines commented out the procedure returned an execution tick count of 1035 while flashing in the datasheet with each pass through. With these lines uncommented and active it took only 133 tick counts and did not display anything changing in the datasheet while it was running. I don’t know why this is not working in your case since I have used this extensively in the past and it always made a big difference in speed.