Microsoft Outlook 2010 issue with .xlsx attachments
Ever since I installed the Office Suite 2010, I’ve been hitting a wall with my emails. For some reason, I can't open any .xlsx files attached to messages anymore. The weird part? I can still open the old-school .xls files from the 1997-2003 era without any trouble. What am I supposed to do here? I tried doing a little digging on Google, but nothing seems to work.
Edit: Before this update, I was using Office 2007. Back then, if I tried to open an .xlsx file from an email, it would throw about five or six annoying confirmation pop-ups at me, but hey—at least the file actually opened! This 2010 version? It just won't budge. 🤷
Honestly, I’m just glad there are people like you out there who don't have a short fuse. They’re definitely a rare breed, but they're worth their weight in gold.
Prika, you'll get through this way faster if you just take the shortcut approach.
I’ve already laid it out for you step-by-step (sorry, I really don't know how to make it any simpler!), so just put in a little effort and pick up these basics: 1. How to actually enter a formula and drag it down in Excel—you're going to need that for column B. 2. How to format dates and numbers properly, which is essential for column A. 3. The difference between absolute and relative cell references, just so you actually understand how that formula in column B is doing its thing.
You'll feel much better once you've actually solved the problem yourself with a little help from us.
You didn't even tell me—do you really need exact seasons with specific dates, or would quarterly breakdowns work for you? That's the most important part!
Here’s a formula to pull out the quarters. It doesn't align perfectly with the seasons, but hopefully, it does the trick for you! If your dates are sitting in cells A2-A100, just pop this formula into column B2-B100. =IF(MONTH(A2)<4;"I";IF(MONTH(A2)<6;"II";IF(MONTH(A 2)<10;"III";IF(MONTH(A2)<=12;"IV";"ups")))) - This will look at the date and spit out the quarter number—I, II, III, or IV—right next to it. You could swap those out for season names if you wanted, though they won't be scientifically accurate, or anything else you like—just make sure the counting formula below matches what you type here!
Then, how many dates actually fall into each quarter? You can grab those totals using this formula: =COUNTIF($B$2:$B$100;"I")- Just put the formula next to "Winter," then "II" next to "Spring," and so on...
If you can’t actually "get inside" the little house icon, just go to Insert > Shapes, pick the line tool, and draw an X over it twice.
Just double-check one thing—could this be a form meant for printing followed by manual entry? But then again, wouldn't they have sent it as a PDF instead of an unlocked Word doc, right?
You'll need to sign it by hand, using either your left or right hand. So, once everything is filled out, just print it, sign it, and then send it off.
restlessheron19 said:Why would that be? Does it matter if they're sitting in the columns I'm trying to hide?
Nope, the confirmation frames are technically "in front of the columns." If they're placed in, say, column BM, then once you hide the range from "BM:HA," they shift over to column "HB." But as soon as you unhide everything, they jump right back to their original spot at "BM."
Anyway, code : Columns works perfectly fine for me—no errors popping up at all. It’s just weird... one confirmation frame hides my columns, while the other one actually unhides them from "BM:HA."
I'm using Office 2010, though I doubt that makes much of a difference.
First off, you really need to rethink how your sheets are structured. Right now, it’s a bit of a mess. Why is one city listing beers first while another starts with sodas? You should have a consistent order—each beer gets its own row, and each soda gets its own row, across the board. Since you're dealing with multiple cities, you can pretty much assume they'll all carry the same product lineup. Once that's set, fixing things becomes a breeze through consolidation.
Another way to handle this? Put all the data from every city into one single master sheet. Then, you can just use filters to pick the specific city you want, or better yet, use SUMIFS to crunch the numbers based on multiple criteria—like a specific city paired with a certain beer, or a city plus a whole category of drinks.
Honestly, about two-thirds of the work is just getting that structure right during the prep phase. If you do that, the rest is a total walk in the park. But starting with a disorganized pile of data? That's a nightmare.
A Pivot Table would also be a huge help for you here.
Kyle Johnson2 said:??? Is this supposed to be an actual argument?
If I were some hot girl from a small town in the Midwest, I’d probably say: "Oh please, what kind of arguments are these? Only people from the Republican Party would think like that. Honestly, they probably couldn't even figure out how to open Excel, they think Outlook is just some fancy word for a makeover, and they probably think Word is a literal globe!"
driftingeagle16 said:Hey everyone. Can anyone walk me through how to set up AutoText in Microsoft Office 2003?
Using the keyboard is probably your best bet, though you could always use a virtual one. By the way, with those recent updates to federal tech regulations, using the Microsoft Office 2003 suite is actually becoming a big no-no. I just couldn't help myself—go ahead and roast me, just please don't hit me in the head!
Ronald Castillo8 said:thanks... I tried adding it after the 50 and after the "Big" colon and now it finally works...(the book actually has it wrong)!! It said to just use a comma, but if you look at the Microsoft Access help files, it says you need a semicolon, not a comma... The correct function is IIf (that's two capital "I"s and a lowercase "f"); you can type a capital F, but it'll just auto-correct to a lowercase f...
Glad you finally cracked the code. Just a quick clarification here. In all the American books—like stuff by Bill Gates, for example—Excel formulas use commas. But over here, in those exact same formulas, you have to swap that comma out for a semicolon. - Why is it like that? Honestly, I haven't looked into it and I don't really care, so why bother? 🙂 I just learned it pretty fast (mostly by hitting my desk in frustration). - I don't use Access all that much, but those commas in the formulas jump out at me immediately. I think I was a bit vague the first time I mentioned it because I said "replace the comma" when I really meant both types of separators. - It’s the same deal with some of the help files and instructions I have in Excel (they use commas instead of semicolons), so they aren't really helpful to use. hello
Is it just me, or does it look like you wrote IIf instead of If? Did you try typing out (.......>50;"Big";"Small")? I don't see where you swapped those commas for semicolons in both spots here.
Ronald Castillo8 said:I'm running into a bit of trouble with Microsoft Access, and I was wondering if anyone could lend a hand... I'm trying to use an IIf function within Calculated Fields : Queries. I'm plugging it right into the "Field" box, but I keep getting an error message. It keeps highlighting the word "Big" in black. Here is my syntax—does anyone know why I'm getting this "you may have entered an operand without an operator" error?
Size: IIf([Total Amount]>50,"Big","Small")
Try swapping out that comma (,) for a semicolon (;) instead.
I finally dug something up! If anyone else is looking for this kind of thing, feel free to check it out:
Private Sub Worksheet_Change(ByVal Target As Range) Sheet2.Cells(Sheet2.UsedRange.Rows.Count + 1, 1) = Application.UserName Sheet2.Cells(Sheet2.UsedRange.Rows.Count, 2) = Date Sheet2.Cells(Sheet2.UsedRange.Rows.Count, 3) = Target.Address Sheet2.Cells(Sheet2.UsedRange.Rows.Count, 4) = Target.Value
If Target.Interior.Color <> vbGreen Then Target.Interior.Color = vbGreen Else Target.Interior.Color = vbRed End If End Sub
So, what does this code actually do? - It logs changes made in Sheet1 over to Sheet2. It grabs the username in column A, the date of the change in B, the specific cell address in C, and the new value in D. Plus, it toggles the cell color in Sheet1 between green and red every time you update an entry. Pretty handy, right?
EXCEL - quick little hiccup here!!!! In columns A, B, C, and D on sheet1, I’ve entered some data and sent it off to users to work with. The people using this file have permission to edit those values, but I really need to know which specific cells they've changed from my original numbers. Is there a way to make a cell change color automatically—maybe turn the number a different color or just something super obvious? - I’ve used a method like this once before, but honestly, it was ages ago. I can't remember where I saved the instructions or how the setup worked. I'm currently drowning in deadlines and just don't have the bandwidth to go hunting for answers, so please bear with me! (Works for Excel 2007 or 2010, doesn't matter much to me). - These details are for monthly reports, so we're looking at changes happening throughout the entire year.
EDIT: Oh, right—"Track Changes" didn't really do it for me. Not quite what I'm looking for. I'm hoping to get some help before midnight, otherwise, I've got to head out and return some shoes. 🙂 Thanks in advance!
Yeah, I've tested this out in the real world a hundred times over.
The values in the first column of the table array must be in ascending order; otherwise, VLOOKUP might not pull the right data. If you need to fix it, just head over to the Data menu, hit Sort, and pick Ascending. Check out the section on Default sort orders if you want to dive deeper.
Sorry for writing this in English—I just didn't feel like typing in my native language right now.
driftingpilot8 said:I'm copying columns over from Microsoft Word, but I don't get it—is this supposed to work with VLOOKUP?
Just look up VLOOKUP (that Microsoft Excel function) on Google or check out some tutorials on YouTube. The main thing is that your lookup data has to be sorted by that first column. It looks like yours is in the left column already, which is good. Just make sure there aren't any blank rows—that's what Nicholas King meant. Basically, once you type those codes into Column A, it should automatically pull both values for you.
- Once you spend a little time studying how VLOOKUP actually works, it'll all click. It's hard to explain just like that, right?
1. This usually happens with those budget printers that just gobble up paper like crazy like a cow in a pasture 2. Check your drivers—make sure you actually have the specific ones for your model, or maybe something close enough 3. Something else, I don't know... maybe look up the specs? See if there are any print limits or restrictions on that machine