OK, found the sheet.
Had to copy it from the machine I used the sheet on last month as can't
access physically the machine ATM.
The sheet was working fine on that machine but produces the symptoms you
mention on this laptop. I will see if I can find the cause.
Steve
On 4/01/23 8:51 am, Steve
That happens to me with some list emails, easiest solution is to add a
rule to prevent classing as spam.
Steve
On 5/01/23 5:36 am, Tim-L wrote:
Your mail list emails are now being marked as spam. Why, I cannot
find out.
On 1/3/23 14:51, Steve Edmonds wrote:
I understand what you are
Your mail list emails are now being marked as spam. Why, I cannot find out.
On 1/3/23 14:51, Steve Edmonds wrote:
I understand what you are seeing, I had the same issue with a macro
for a function, I called it money() for rounding financial tax
calculations appropriately. At some point
I understand what you are seeing, I had the same issue with a macro for
a function, I called it money() for rounding financial tax calculations
appropriately. At some point when I updated LO it just stopped
calculating displaying as you describe and I had to go through the same
rigmarole you
Recalculate:
Force recalculate - F9 by default, but could be reassigned. OR on the menu
at Data --> Calculate --> Recalculate
There's also "recalculate hard" which is (probably misunderstood by me)
like the first calculate on load. CTRL-F9 or the same menu as recalculate.
___
Macros:
I am having trouble following what is happening (and I guess I missed the first
reply.
First, it looks like the cell D2 is calling a macro.
If I understand, the cells are NOT recalculating so you are causing each one to
run manually. What happens if you use
Data > Calculate > Recalculate
On 3/1/23 09:13, Michael Tiernan wrote:
On 12/23/22 11:02 AM, Andrew Pitonyak wrote:
If you are looking to cause functions to recalculate,
Thanks for the reply.
Here's the thing. It's not that I want to force a recalculate, it's
that I have to in order to get the macros to respond.
Here's
On 12/23/22 11:02 AM, Andrew Pitonyak wrote:
If you are looking to cause functions to recalculate,
Thanks for the reply.
Here's the thing. It's not that I want to force a recalculate, it's that
I have to in order to get the macros to respond.
Here's an example: (What I expect when the
No computer access Right now so everything I say is going to be a guess.
If you are looking to cause functions to recalculate, I think that might be a
setting not related to macros. Because you can turn off auto recalculation.
Also, you can force a full update. I know it's on the menu. I don't
I have a couple of BASIC macros in a spreadsheet.
I keep thinking that there must be a "init" function that isn't being
called because each time I open the spreadsheet, the macros don't run. I
have to mess about a bit and then force each cell to recalculate
manually. (I'm sure that there's a
10 matches
Mail list logo