Date   

moderated Re: Excel Issue

Van Lant, Robin
 

I don't typically have issues with Excel 365 and Windows 10 unless I'm working with Pivot Tables or large files with autofiltering enabled, then it can crash at times. I haven't figured out the pattern, but I'll be working in a very large Excel file over the next few weeks, , so I'll try to take notes.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Saturday, September 14, 2019 9:04 PM
To: main@jfw.groups.io
Subject: Re: Excel Issue

Is this in Windows 7 or Windows 10? I use Excel via Office 365 on a Windows 10 computer with Jaws 2019 and I can use it all day long without any issues whatsoever.



-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Friday, September 13, 2019 7:35 PM
To: main@jfw.groups.io
Subject: Re: Excel Issue

JAWS has trouble working with Excel for over half an hour or so. Sometimes unloading/reloading JAWS will fix it. Sometimes we have to do a complete JAWS shut down and restart. Sometimes it requires a reboot. It's the combination of JAWS and Excel. Sometimes even JAWS and Word,but not as often.
eAt 09:00 PM 9/12/2019, you wrote:
Lately, I have noticed that when I am in Excel, and I am in a
spreadsheet, which I have been using regularly, Excell shuts down when
I want to make a new entry. The spreadsheet is not protected.
When I shut everything down and just have the spreadsheet running ther
is no problem.

I also notice rthat if I shut down JAWS and bring it back up, the
problem goes away for a little while. Any ideas?








This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the
SUBJECT line.


moderated "R1C1 reference style". Be sure this box is not checked. RE: Need help with an Excel formula

Van Lant, Robin
 

It’s also good to note that formulas like this don’t work if your spreadsheet has gotten switched to R1C1 cell referencing.   This occasionally happens to me if I download a report from certain programs.  However it occurs, you can check and change this setting under File / Options / Formulas and tab to the first checkbox under Working with Excel formulas,   In my recollection, JAWS still reads cell references at A1, B2, and so on, even if the reference style e gets switched.  I usually figure out I’m having a problem only when I try to type in a formula and it dosen’t recognize the alphanumeric cell references.

 

 

 

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 1:11 PM
To: main@jfw.groups.io
Subject: Need help with an Excel formula

 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 



This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114


If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.


moderated Re: Problems with Outlook 365

 

Office version 2019 applies only to the retail version of Office.

If you are subscribed to Office 365 your version will still read something like 16.0.12026.20108 which is what it currently shows for me.

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of John Gurd via Groups.Io
Sent: Monday, September 16, 2019 12:39 AM
To: main@jfw.groups.io
Subject: Re: Problems with Outlook 365

 

How do I switch to the monthly channel for updates of Office 365? I’ve just tried to update and been advised my latest update was October 2018 and I am up-to-date. On checking I still appear to be on the 2016 build. I have 3 machines and they all report the same thing including one which is new on which 365 was installed 4 weeks ago. I am in the UK but I assume I should still be on the 2019 build.

 

Thanks

 

John

John Gurd


On 11 Sep 2019, at 3:53 pm, Cohn, Jonathan <jcohn@...> wrote:

A lot of my Outlook hangs got resolved in the build that came out a few weeks ago. Also, I have heard some chatter about versions of Office from a few months back havig issues that are resolved in the newer versions. If you are not on the "monthly" channel of Office updates, you might want to consider being on it.  In either case, FS Support should be able to quickly verify if they know of issues with either your JAWS or Office versions.your version number is something like 2019.190


moderated Re: Need help with an Excel formula

Shirley Tracy
 

Hi Allen,

 

You must be reading my spread sheet. 😊 Absolutely on base. Thank you. That’s just what I wanted.

 

I have manually put in the starting balance (from the prior month), but the calculations were in error after that, so I knew something had to be wrong. That’s when I tried keying in the formula instead of copying it from sheet to sheet. Same problem. But what you gave me is just what I needed. Thanks.

 

So you really can teach an old dog new tricks. I’ll be 74 next month and I’m still learning.

 

Shirley

 

PS Thanks to everyone else who responded.

 

 

Shirley Tracy

 

From: Alan Lemly
Sent: Sunday, September 15, 2019 8:09 PM
To: main@jfw.groups.io
Subject: Re: Need help with an Excel formula

 

Hi Shirley,

 

What might be wrong with your formula is hard to diagnose with the information you've provided. I'll state what I think your bank debits and deposits spreadsheet looks like and we'll go from there. I suspect row 1 is your column headings and that column D contains debits, column E contains deposits, and column F contains a running balance. Assuming you use a different spreadsheet for each month, I would suggest that cell F2 be the opening balance for the month which should equal your closing balance from the previous month's spreadsheet. I personally would manually input the starting balance for cell F2 because I'm not a big fan of using formulas to bring amounts from other spreadsheets. Row 3 should contain the activity for the current month so the formula in cell F3 would be =(F2-D3+E3). I expect columns A through C contain date, description, and some other text field but those don't have formulas and don't seem to be giving you a problem.

 

I would check to make sure your opening balance in cell F2 is a manually input number and then I would input the formula I provided above into cell F3 and go from there. If you're still having problems, make sure columns D through F are formatted as numbers.

 

Good luck.

 

Alan Lemly

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM
To: main@jfw.groups.io
Subject: Need help with an Excel formula

 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 

 


moderated Re: Problems with Outlook 365

John Gurd
 

How do I switch to the monthly channel for updates of Office 365? I’ve just tried to update and been advised my latest update was October 2018 and I am up-to-date. On checking I still appear to be on the 2016 build. I have 3 machines and they all report the same thing including one which is new on which 365 was installed 4 weeks ago. I am in the UK but I assume I should still be on the 2019 build.

Thanks

John

John Gurd

On 11 Sep 2019, at 3:53 pm, Cohn, Jonathan <jcohn@...> wrote:

A lot of my Outlook hangs got resolved in the build that came out a few weeks ago. Also, I have heard some chatter about versions of Office from a few months back havig issues that are resolved in the newer versions. If you are not on the "monthly" channel of Office updates, you might want to consider being on it.  In either case, FS Support should be able to quickly verify if they know of issues with either your JAWS or Office versions.your version number is something like 2019.190


moderated Re: Need help with an Excel formula

Glenn / Lenny
 


Some of my spreadsheets have quite a few formulas in them, so I typically just save it under another name, and go in and delete the variable data for a clean spreadsheet.
Glenn
 

----- Original Message -----
From: Alan Lemly
Sent: Sunday, September 15, 2019 4:40 PM
Subject: Re: Need help with an Excel formula

Hi Shirley,

 

What might be wrong with your formula is hard to diagnose with the information you've provided. I'll state what I think your bank debits and deposits spreadsheet looks like and we'll go from there. I suspect row 1 is your column headings and that column D contains debits, column E contains deposits, and column F contains a running balance. Assuming you use a different spreadsheet for each month, I would suggest that cell F2 be the opening balance for the month which should equal your closing balance from the previous month's spreadsheet. I personally would manually input the starting balance for cell F2 because I'm not a big fan of using formulas to bring amounts from other spreadsheets. Row 3 should contain the activity for the current month so the formula in cell F3 would be =(F2-D3+E3). I expect columns A through C contain date, description, and some other text field but those don't have formulas and don't seem to be giving you a problem.

 

I would check to make sure your opening balance in cell F2 is a manually input number and then I would input the formula I provided above into cell F3 and go from there. If you're still having problems, make sure columns D through F are formatted as numbers.

 

Good luck.

 

Alan Lemly

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM
To: main@jfw.groups.io
Subject: Need help with an Excel formula

 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 


moderated Re: Need help with an Excel formula

 

Hi Shirley,

 

What might be wrong with your formula is hard to diagnose with the information you've provided. I'll state what I think your bank debits and deposits spreadsheet looks like and we'll go from there. I suspect row 1 is your column headings and that column D contains debits, column E contains deposits, and column F contains a running balance. Assuming you use a different spreadsheet for each month, I would suggest that cell F2 be the opening balance for the month which should equal your closing balance from the previous month's spreadsheet. I personally would manually input the starting balance for cell F2 because I'm not a big fan of using formulas to bring amounts from other spreadsheets. Row 3 should contain the activity for the current month so the formula in cell F3 would be =(F2-D3+E3). I expect columns A through C contain date, description, and some other text field but those don't have formulas and don't seem to be giving you a problem.

 

I would check to make sure your opening balance in cell F2 is a manually input number and then I would input the formula I provided above into cell F3 and go from there. If you're still having problems, make sure columns D through F are formatted as numbers.

 

Good luck.

 

Alan Lemly

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM
To: main@jfw.groups.io
Subject: Need help with an Excel formula

 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 


moderated Re: Does the latest ITuneds work with JFW 2019?

 

I wouldn’t quite call it a horror and if you have an iPhone you may not have a choice but to use it for a few things. But if all you are concerned about it having an app for your music, making playlists and playing them then I agree that iTunes wuldn’t be my first choice.

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Jaffar Sidek
Sent: Friday, September 13, 2019 3:24 PM
To: main@jfw.groups.io
Subject: Re: Does the latest ITuneds work with JFW 2019?

 

Hi. I wouldn't wish ITune for Windows on my worst enemy.  Stick to Winamp or Groove Music or Windows Media player even and they should do a more then adequate job of allowing you to organize your music collection.  ITunes is excellent on the mac, but  a horror on windows.  Cheers!

On 9/14/2019 2:07 AM, Kevin Meyers wrote:

I started to use Itunes with Jaws 2019 and doesn’t work to well. I have a hard time with the playlists I created to show. Then when I navigate around eventualy a certain playlist shows. At least I thought it did. Then I press enter on the play button and it plays a song in a different playlist. Is there a way to change something in Jaws settings or Itune settings to get it to work better?

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: Friday, September 13, 2019 12:34 PM
To: main@jfw.groups.io
Subject: Re: Does the latest ITuneds work with JFW 2019?

 

It isn't any worse.

What areas are you most concerned with?

 

Richard

 

Always look out for #1, and be careful not to step in #2. 

 




On Sep 13, 2019, at 9:10 AM, Ralph Supernaw <rhs@...> wrote:



Hi,

 

I have been putting off letting ITunes update to the latest version.  Before I do I thought I’d find out if I will regret it.

 

Thanks.


moderated Re: Does the latest ITuneds work with JFW 2019?

 

Except if it's a 32-bit app where the developer never bothered to change it 64-bit, in this case you maybe able to install it on your iPhone (not sure), but it sure won't run since only 64-bit apps will work.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of netbat66
Sent: Friday, September 13, 2019 11:21 AM
To: main@jfw.groups.io
Subject: Re: Does the latest ITuneds work with JFW 2019?

if anyone still has i tunes version 12.60 i would not upgrade. this is the last version that allows you to backup your apps on your computer.
at least if you have bought an app and it is removed from the apple app store you would still have it on your computer and could reinstall it.
you can not do this with the newest i tunes version.

-----Original Message-----
From: Ralph Supernaw
Sent: Friday, September 13, 2019 9:10 AM
To: main@jfw.groups.io
Subject: Does the latest ITuneds work with JFW 2019?



Hi,



I have been putting off letting ITunes update to the latest version. Before I
do I thought I’d find out if I will regret it.



Thanks.


moderated Re: Windows 10 and emojis

David Diamond
 

I tried it in sending a message to myself via computer and even in a post on Facebook.  It worked in both situations.  😊

 

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Maria Campbell
Sent: September 15, 2019 4:08 PM
To: main@jfw.groups.io
Subject: Re: Windows 10 and emojis

 

I brought it up but I had to go to the desktop.

 

 

Maria Campbell

lucky1inct@...

 

All that is necessary for evil to triumph is for good people to do nothing.

 

On 9/15/2019 7:06 PM, Kevin Meyers wrote:

> Nothing happens when I press windows key and the period. Is there some

> other keys I can bring this up?

> -----Original Message-----

> From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard

> Weitzel

> Sent: Sunday, September 15, 2019 4:45 PM

> To: main@jfw.groups.io

> Subject: Re: Windows 10 and emojis

> Windows + Period brings up the emoji panel and you can arrow around or

> if you type something like "face" or grin" it will show only emojis like that.

> -----Original Message-----

> From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy

> Barnett

> Sent: Saturday, September 14, 2019 4:32 PM

> To: main@jfw.groups.io

> Subject: Re: Windows 10 and emojis

> After doing windows period  Did you tab?

> Randy Barnett owner of soundtique

> On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@...> wrote:

> Hi all,

> I wondered whether anyone has found an accessible way to type emojis

> in Windows 10 using JAWS 2019.

> I have tried by bringing up the Windows touch keyboard from the System

> Tray, but don't seem to be able to enter the emojis using JAWS

> commands on the physical keyboard - I have tried the touch cursor without success.

> I have had limited success in finding emojis on the screen itself, but

> scrolling is a bit unreliable/at an awkward angle as I'm using a laptop.

> I have tried a couple of windows shortcuts which are meant to bring up

> emojis - Windows semi-colon and Windows period, but they don't seem to work.

> Does anyone have any suggestions either things I can do differently

> using the methods I've already tried or something else?

> Cheers,

> Ed

>

 

 


moderated Re: Need help with an Excel formula

Kevin Meyers <kevinmeyers@...>
 

I put your formula in my spread sheet and it works. Maybe add sum to the formula. Like:

 

=sum(E3-D3)+F2

 

Both ways worked in my spread sheet.

 

Kevin

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Shirley Tracy
Sent: Sunday, September 15, 2019 2:11 PM
To: main@jfw.groups.io
Subject: Need help with an Excel formula

 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 


moderated Re: Windows 10 and emojis

Maria Campbell
 

I brought it up but I had to go to the desktop.


Maria Campbell
lucky1inct@...

All that is necessary for evil to triumph is for good people to do nothing.

On 9/15/2019 7:06 PM, Kevin Meyers wrote:
Nothing happens when I press windows key and the period. Is there some other
keys I can bring this up?

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, September 15, 2019 4:45 PM
To: main@jfw.groups.io
Subject: Re: Windows 10 and emojis

Windows + Period brings up the emoji panel and you can arrow around or if
you type something like "face" or grin" it will show only emojis like that.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy Barnett
Sent: Saturday, September 14, 2019 4:32 PM
To: main@jfw.groups.io
Subject: Re: Windows 10 and emojis

After doing windows period Did you tab?

Randy Barnett owner of soundtique

On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@...> wrote:

Hi all,

I wondered whether anyone has found an accessible way to type emojis in
Windows 10 using JAWS 2019.

I have tried by bringing up the Windows touch keyboard from the System Tray,
but don't seem to be able to enter the emojis using JAWS commands on the
physical keyboard - I have tried the touch cursor without success.

I have had limited success in finding emojis on the screen itself, but
scrolling is a bit unreliable/at an awkward angle as I'm using a laptop.

I have tried a couple of windows shortcuts which are meant to bring up
emojis - Windows semi-colon and Windows period, but they don't seem to work.

Does anyone have any suggestions either things I can do differently using
the methods I've already tried or something else?

Cheers,

Ed












moderated Re: Windows 10 and emojis

Kevin Meyers <kevinmeyers@...>
 

Nothing happens when I press windows key and the period. Is there some other
keys I can bring this up?

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Sieghard Weitzel
Sent: Sunday, September 15, 2019 4:45 PM
To: main@jfw.groups.io
Subject: Re: Windows 10 and emojis

Windows + Period brings up the emoji panel and you can arrow around or if
you type something like "face" or grin" it will show only emojis like that.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy Barnett
Sent: Saturday, September 14, 2019 4:32 PM
To: main@jfw.groups.io
Subject: Re: Windows 10 and emojis

After doing windows period Did you tab?

Randy Barnett owner of soundtique

On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@...> wrote:

Hi all,

I wondered whether anyone has found an accessible way to type emojis in
Windows 10 using JAWS 2019.

I have tried by bringing up the Windows touch keyboard from the System Tray,
but don't seem to be able to enter the emojis using JAWS commands on the
physical keyboard - I have tried the touch cursor without success.

I have had limited success in finding emojis on the screen itself, but
scrolling is a bit unreliable/at an awkward angle as I'm using a laptop.

I have tried a couple of windows shortcuts which are meant to bring up
emojis - Windows semi-colon and Windows period, but they don't seem to work.

Does anyone have any suggestions either things I can do differently using
the methods I've already tried or something else?

Cheers,

Ed


moderated Re: Windows 10 and emojis

 

Windows + Period brings up the emoji panel and you can arrow around or if you type something like "face" or grin" it will show only emojis like that.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Randy Barnett
Sent: Saturday, September 14, 2019 4:32 PM
To: main@jfw.groups.io
Subject: Re: Windows 10 and emojis

After doing windows period Did you tab?

Randy Barnett owner of soundtique

On Sep 14, 2019, at 1:19 PM, Edward Green <ergreen1981@...> wrote:

Hi all,

I wondered whether anyone has found an accessible way to type emojis in Windows 10 using JAWS 2019.

I have tried by bringing up the Windows touch keyboard from the System Tray, but don't seem to be able to enter the emojis using JAWS commands on the physical keyboard - I have tried the touch cursor without success.

I have had limited success in finding emojis on the screen itself, but scrolling is a bit unreliable/at an awkward angle as I'm using a laptop.

I have tried a couple of windows shortcuts which are meant to bring up emojis - Windows semi-colon and Windows period, but they don't seem to work.

Does anyone have any suggestions either things I can do differently using the methods I've already tried or something else?

Cheers,

Ed


moderated Re: Need help with an Excel formula

Marty Hutchings
 

I would need to know your columb titles before I could help you.  I also use Excel for bank ledgers, but your formula is a little different than mine.
 
Love in Christ
Marty
For our struggle is not against flesh and blood, but against the rulers, against the powers, against the world forces of this darkness, against the spiritual forces of wickedness in the heavenly places.
Therefore, take up the full armor of God, so that you will be able to resist in the evil day, and having done everything, to stand firm.
Ephesians 6:12, 13
 

Sent: Sunday, September 15, 2019 2:11 PM
Subject: Need help with an Excel formula
 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 


moderated Re: Need help with an Excel formula

Glenn / Lenny
 


Hi Shirley,
I find it easiest to just copy the contents of the cell with the formula and pasting it elsewhere.
So I would have both spread sheets open, and go to the cell where the formula works, and do control + C to copy, and control + tab to the other spreadsheet and move to where you want the formula, and paste it with control + V.
HTH.
Glenn

----- Original Message -----
Sent: Sunday, September 15, 2019 2:11 PM
Subject: Need help with an Excel formula

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 


moderated Need help with an Excel formula

Shirley Tracy
 

Hi Listers,

 

First, I do not fully know how to use Excel like many of you who probably use it for work. But I do use it for keeping our Writers Club’s roster and my bank account spread sheets. I used to have a formula that I could use in keeping a spread sheet of my bank debits and deposits—balancing my account. The formula I was given was =(E3-D3)+F2 and it helped me keep account of the totals when putting in debits and credits. Used to work great. Now, however, when I start a new monthly spread sheet, I get a message that the formula I key in is an error. I don’t know if something has gotten erased from the formula I had in my original file, or if the formulas have changed over time. Otherwise, I have no need to learn Excel. Can someone just please help me with this formula or tell me what might be wrong?

 

Thank you.

 

Shirley

 

 

 

 


moderated Re: Absolutely Essential Information to Share When You Have an Issue and How to Get It

David Diamond
 

True however, some don’t know those things so it is good you provided steps to do that.  Like I said, it is a symbiotic relationship. When someone calls me, often they just say, “My dog has issues.”  It is up to me to assess by asking the correct questions what those issues are.   

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Brian Vogel
Sent: September 15, 2019 11:30 AM
To: main@jfw.groups.io
Subject: Re: Absolutely Essential Information to Share When You Have an Issue and How to Get It

 

On Sun, Sep 15, 2019 at 12:27 PM, David Diamond wrote:

So it’s up to the doctor to ask the right questions. It is, a symbiotic relationship. 

Indeed, but OS Version, Screen Reader Version, and specific software version are the patient's responsibility, and the rough equivalent of Name, Address, and Phone Number.

It needs to be automatically provided, not pried out each and every time.
 
--

Brian - Windows 10 Pro, 64-Bit, Version 1903, Build 18362  

Many of the insights of the saint stem from his experience as a sinner.

         ~ Eric Hoffer


moderated Re: Absolutely Essential Information to Share When You Have an Issue and How to Get It

 

On Sun, Sep 15, 2019 at 12:27 PM, David Diamond wrote:
So it’s up to the doctor to ask the right questions. It is, a symbiotic relationship. 
Indeed, but OS Version, Screen Reader Version, and specific software version are the patient's responsibility, and the rough equivalent of Name, Address, and Phone Number.

It needs to be automatically provided, not pried out each and every time.
 
--

Brian - Windows 10 Pro, 64-Bit, Version 1903, Build 18362  

Many of the insights of the saint stem from his experience as a sinner.

         ~ Eric Hoffer


moderated Re: getting rid of inline objects in word

JM Casey
 

Haha..I wouldn’t have said anything, except seeing “carrot” there really cracked me up. I use a braille display more than speech nowadays so these things just jump out at me more.

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kimsan via Groups.Io
Sent: September 15, 2019 2:27 AM
To: main@jfw.groups.io
Subject: Re: getting rid of inline objects in word

 

Jm Casey,

Lmao, my bad. I just went with the first spell check suggestion.

 

Best regards,

 

Kimsan Song

 

kimsansong@...

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of JM Casey
Sent: Saturday, September 14, 2019 11:16 AM
To: main@jfw.groups.io
Subject: Re: getting rid of inline objects in word

 

Hey. Glad that method worked for you. It didn’t exactly work for me when I tried it last, but that was a large document OCRed by Adobe Aacrobat and converted to  a word document. There may have been all sorts of weird issues with it.

 

BTW, it’s “caret”, not “carrot”, the vegetable. 8grins*

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kimsan via Groups.Io
Sent: September 13, 2019 4:50 PM
To: main@jfw.groups.io
Subject: Re: getting rid of inline objects in word

 

Hi,

I found the answer.

CTRL h for find and replace, type carrot g, in the next box leave it empty, then hit replace all.

All gone.

 

Best regards,

 

Kimsan Song

 

kimsansong@...

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Kimsan via Groups.Io
Sent: Thursday, September 12, 2019 9:08 AM
To: 'jfw' <jfw@groups.io>
Subject: getting rid of inline objects in word

 

Hi,

Jaws 2019, windows 10 pro latest and word 2016.

 

I press CTRL shift o, there are 218 inline objects, I thought by selecting all with CTRL a and tapping delete would do the trick, but to no avail.

How can I quickly remove these?

Thank you,

Sincerely,

Kimsan Song

kimsansong@...