User Profile
mathetes
Silver Contributor
Joined 6 years ago
User Widgets
Recent Discussions
"Correct highlighted errors" but there ain't any
Grahmfs13cuong Just calling your attention, my friends, to a weird occasional occurrence. Every once in a while I get this kind of thing asking me to correct highlighted errors and try again. Trouble is, no errors are highlighted in the message!So I'm left to fend for myself. Usually I find that if I ignore and just keep trying to post, it eventually will post, with nothing having been changed. Down at the bottom you'll see a reference saying "invalid HTML was found in the message body" -- which is interesting because I've not actually entered any HTML myself; any and all formatting was done using the tool bar that appears at the top of the message box, so whatever HTML is present was created by the message board software itself, the very software that is now correcting itself....Why am I getting the #BLOCKED! error?
Hi, friends The "#BLOCKED!" error below is in Excel, and (as you can see) it's saying I'm "Not signed in"; but I am. I have signed in both when starting Excel this morning AND when starting up the computer and having OneDrive start up. I changed the password for Microsoft last week, so had to sign-in with that new password. Why then am I getting this error and what can I do about it? I do see that I have the option of Signing Out and presumably signing in again, but signing out comes with all kinds of dire warnings"#Blocked" eror in Microsoft
The "#BLOCKED!" error below is in Excel, and (as you can see) it's saying I'm "Not signed in"; but I am. I have signed in both when starting Excel this morning AND when starting up the computer and having OneDrive start up. I changed the password for Microsoft last week, so had to sign-in with that new password. Why then am I getting this error and what can I do about it? I do see that I have the option of Signing Out and presumably signing in again, but signing out comes with all kinds of dire warningsA question about Microsoft's password management system
I travel a fair amount, so am often logging in on my laptop from a new spot. This site to its credit recognizes that and asks me to login from scratch. But when I do it can become problematic if I make the slightest mistake in the password. Specifically one mistake leads to a message to the effect "Too many mistaken attempts; you must change your password" But it's never really "too many"--just one. And from there it gets worse, because when I do change the password and then try to immediately use that new password, it doesn't get recognized (though I'm sure I've done it correctly) and I'm directed yet again to change it. But if I wait, oh, ten minutes to log in, that new password works. Leading me to think that Microsoft's own process for recording and implementing the new password takes a few minutes (for some unimaginable reason). It happened to me again last evening, twice. I was even told finally that I'd made too many attempts to change the password and would have to try again this morning. BUT I ignored that advice, waited about 15 minutes, came back and logged in successfully with the final password I'd set (despite MSFT having told me I'd have to wait till today)...... Have any of you experienced this? Or problems like it? cuongIs it a known issue, per chance? It's a big inconvenience, not so much because it interferes with my participation in this forum (though that is a concern), but more because it also means my OneDrive subscription is blocked for the duration, since it relies on the same credentials.Can INDIRECT be used to dynamically alter the second range reference in a Named Range
I have a workbook that retrieves data from another spreadsheet, the latter being downloaded from my brokerage. Occasionally the number of rows in the downloaded sheet goes up or down, based on buying or selling securities. After retrieving the data into the active workbook, I have a named range that includes all the data i need; and I then use VLOOKUP to access whatever data I need elsewhere in the workbook. As noted the range usually is stable, but when there's a new row or two, or when I've sold some securities so the number of rows declines, I've been manually altering the range reference in the Named Range box. Today I tried to used COUNT to capture the number of rows dynamically, and then created an A1 reference and tried to use INDIRECT to reference that from within the Insert Name dialog box. It appeared to accept the INDIRECT, but the named range didn't work. So my question is whether that's even possible.
