Search results

Hi, all! I have a non-macro file (.xlsx) which I can't transform in a macro file (.xlsb or .xlsm) due to security policies. There is a worksheet that shows the actual time (let's say A1: =NOW()), but it only gets updated if a cell in the worksheet is modified or user recalculates it manually...

Hi, all! I'm trying to play with prime numbers and implementing several methods for calculating them. When arrived to Eratosthenes' sieve I need to use as much as memory as possible, so my algorithm starts dimensioning an array and sizing downwards until no Error 7 Out of Memory happen. Then I...

Hi, all! I have a workbook that solves the problem of finding the optimal way to go thru a group of addresses identified by their geographic coordinates, in order to minimize the distance. Technically speaking, It is developed using VBA and array formulas, as it was originally intended to be...

I recently read an article about Andrew Wiles who solved the last theorem of Fermat in 1993 and published two years later. I would like to know if anybody could do it in Excel. It is an ideal exercise for those who are looking for interesting challenges, isn't it? F.G.