Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

rustywalker1 said:how do you do exponents in Word 2003? 😁

here FIRST LINK

and this one's the second

- Exponent in Word

I've got a question too, assuming anyone can actually make sense of what I'm saying here 🙂

It’s about Excel.

So, look, I have these different clients who owe me various amounts of money.
Since the names repeat, I went ahead and sorted them alphabetically so all the same people are lined up right under each other. Then, after sorting, I needed to get the total debt for each individual—so, fine, I set up a new column for that and did my thing.
But now I've hit a massive wall!! 😠

I need to take that column with the totals and sort it from the largest debt down to the smallest, and for some reason, it just won't fucking work! 🙂

If I try to use the standard sort or a filter, it moves the numbers, BUT obviously they stay stuck in the rows where those summation formulas were sitting, so when everything shifts, it starts calculating totally wrong results! 🙂 Does anyone actually follow me?

Basically, what I'm asking you guys is: is there a way to just simply rearrange those totals without the program trying to recalculate everything from scratch!!

Thanks 🙂

Kyle Johnson2 said:Here we go. First link.

And here’s the second one.

- How do you add an exponent in Word?

🤣

I forgot to search in English, and now everything is showing up in a language I can't even read. Why does this always happen? Left. It crashed.

Grace Martin83 said:Actually, I’ve got a question myself too

Take a look at these if you think they might help you out:

http://office.microsoft.com/en-us/ex...010342909.aspx or maybe this one:
http://www.practicum.com/office/excel/xl_076.asp

Hey everyone, I'm running into a bit of a headache with my Office 2007...
Every time I try to open Word, PowerPoint, or any other program in the suite, it tries to trigger some kind of installation process.
Everything is already installed, but a little window pops up saying it can't find something. I just hit cancel, and everything works fine after that, but that annoying pop-up is driving me crazy! Does anyone know how I can get rid of it? Any help would be appreciated! 😁

Walter Jackson48 said:Check these out, maybe one of them will actually help you:

http://office.microsoft.com/en-us/ex...010342909.aspx or this:
http://www.practicum.com/office/excel/xl_076.asp

Thanks for the reply. I literally fixed the whole thing in like two clicks using Pivot Tables 😉 They are absolute lifesavers!

I am experiencing issues with Microsoft Access again. 🙂

I was tinkering with some settings and managed to get it working a few times, but now I am stuck. When I try to enforce referential integrity in the relationships window, I receive this error: "No unique index found for the referenced field of the primary table." I am unsure where my mistake lies. If anyone is knowledgeable in this area, could you please explain the specific requirements for linking two tables via a field while ensuring that integrity is maintained?

Additionally, I need guidance on how to implement the following logic:
Prevent entering a club ID in Table 123 if that club does not exist in Table 456.
Prevent deleting a club ID in Table 456 if there is an associated competitor from that club listed in Table 123, while still allowing the ID to be modified.

Finally, I have one more question:
What is the purpose of the Lookup feature, and in what scenarios should it be utilized?

Any assistance would be greatly appreciated.

I need urgent help here.
I was running a Compact and Repair on an old Microsoft Access database I've been working on. Everything seemed fine initially—I could open the file and see all my tables—but then everything went sideways. For some reason, I’ve completely lost my Admins permissions. Now, whenever I try to access it, I get this error: "Could not read definitions; no read definitions permission for table or query 'Pero'."
I tried going to Tools > Security > User and Group Permissions > Change Owner, and while it shows the Admin option, it won't let me actually assign it.
I've already wasted time searching Google and trying every standard fix out there, but nothing is working.
I really need a solution quickly because I have a major reconstruction project on my plate right now.
🙂

Thanks.

Was there any kind of workgroup security set up on that database—you know, like if the file was shared and they actually bothered to create specific users and groups with custom permissions?

If not, your best bet might be to try a decompile. Just hit start -> run -> msaccess.exe "drive\path\file name.mdb" /decompile

Was the database behaving itself before you ran a Compact? And please tell me you have a backup copy somewhere... 🙂

The database was running perfectly fine until everything just went south. I restored from a backup, but of course, it’s the usual story—it only goes back three days, so now I’m stuck manually patching the data gap.
The permissions were standard, too; nothing unusual regarding specific user groups.

Benjamin King2 said:Was there any kind of workgroup security implemented on this database? I mean, was it a shared file with specific users and groups set up with permissions?

If not, try running a decompile. Hit Start -> Run -> msaccess.exe "drive\path\file name.mdb" /decompile

Was the database running fine before you ran the Compact process? Don't you have a backup copy? 🙂

I did exactly what you suggested, but nothing changed.
It ran, the database opened, and I can see the tables, but the issue is still there.

How do I fix my text formatting? I want the paragraphs under 1. and 2. to line up perfectly.

I was out. I was out. I was out. I was out.
1) I was out. I was out.
I was out. I was out.
2) I was out. I was out.
I was out. I was out.
I was out. I was out. I was out.

Help! 😠
Thanks so much!

Hey there,

So, I'm running into this weird little headache with my Table of Contents... basically, I'm trying to get it to look exactly like this:

1.
. 1.1.
. 1.2.
2.
. 2.1.
. 2.2.

but for some reason, everything is just acting up and giving me this mess instead:

1.
. .1.1.
. . . . 1.2.
2.
. .2.1.
. . . . 2.2.

I guess I'm just wondering if anyone knows how to tweak the settings to fix this? Maybe there's a specific way to set it up?

Thanks a bunch!

Zachary Moore56 said:I followed your instructions to a T, but absolutely nothing changed.
I ran the process—it finished, the database opened, I can see all the tables—but honestly, it’s the exact same mess as before.

Look, there's probably some corruption lurking in the database—and frankly, I have no clue how you're supposed to hunt down the specific culprit... just try creating a totally blank database, then copy your objects over from a non-compacted version and see if you can actually view or edit them normally.

Benjamin King2 said:It’s likely some corruption within the database itself. Honestly, I have no clue how you're supposed to pin down the exact cause. Try creating a completely blank database and then copy your objects over from an uncompacted version. See if they behave normally or allow editing once they're moved.

Unfortunately, neither importing nor copying is working at all.😕

What kind of error message are you getting when you try to copy?

So, like the title says...

Alright, here's the deal. I know where the settings are, but I can't figure out how to make the page numbering skip the first two pages and start on the third. It’s for my high school graduation paper, and it looks super unprofessional to have numbers on the cover page and the table of contents. I want to skip those.

Same goes for the header. Honestly, I don't care about that as much, but if anyone knows how to wipe it from those first two pages too, you'd be a lifesaver.

Thanks in advance! 🙂

Jessica Brown25 said:So, like I said in the title...

From what I can gather, you're dealing with two distinct headaches:
1. Getting rid of page numbers on the first two pages.
2. Starting the numbering from a specific number on a random page.

The first issue is solved by splitting your document into two sections using a page break at the end of the second page. Your first section will cover those initial two pages, while the second section will handle everything else starting from page three (you'll need to use a continuous page break at the top of page three). Once you've successfully split the document into two sections—which you'll know you've done if you double-click the header or footer—you can tell Microsoft Word to insert page numbers. Sure, it’s going to slap a number on every single page at first, but since you've partitioned the file into sections, you can just click into that first section and delete the number. If you did everything correctly, the numbers should vanish from the first two pages and pick up normally starting on the third...

As for the second part, here is how you handle it: let's say instead of page 3 showing "3," you want it to show "15" for some reason. In the menu where you go to insert page numbers, look for the "Format Page Numbers" option. Click that, and a window will pop up where you can select "Start at." Just type in whatever number you want (in our case, 15)

Dana Diaz8 said:From what I can tell, you're dealing with two things here:
1. How to ditch the page numbers on the first two pages.
2. How to make a specific page start numbering from whatever number you want.

For the first part, just split your term paper into two sections using a page break at the end of the second page. That first section covers your first two pages, and the second section handles everything else starting from page three (use a continuous section break at the top of page three). Once you've successfully split the doc into two sections—you'll know it worked if you double-click the header or footer—just go ahead and insert page numbers but they'll show up everywhere initially. Since you split the document, just click into that first section and delete the number. If you did it right, those numbers should vanish from the first two pages while staying perfectly intact from page three onwards...

As for the second part, say you don't want page three to actually say "3," but for some reason, you need it to say "15." Just hit "insert page numbers" and look for the "format page numbers" option. A window will pop up where you can select "start at" and just type in your number (in this case, 15).

Man, thanks for putting in the work, that was a super clear explanation. But, once again... I hit the button to number the pages, and sure enough, everything looks fine and every page gets its number.
BUT, when I try to wipe the number off the first or second page, the whole thing disappears. Every single number vanishes. I just can't seem to kill a single number on one sheet without nuking the rest.

And about that second point, that wasn't actually what I was asking.
I put my term paper title, my full name, and my grade level in the header above.
And the exact same thing happens with that as it does with the numbers.
I can edit it, style it, pick any font I want—that part works fine. But I can't get rid of it on those first two pages.
It’s like an all-or-nothing deal. Either the header and numbers are on every single page, or they aren't on any of them.

Jessica Brown25 said:I click to enable page numbering, everything looks perfect at first glance, and every single page actually shows its own number.

Fine, if we aren't doing this my way, let's just go "by the book." Seriously. Just do exactly what I told you, but don't go deleting any numbers. Instead, try this: if you're looking at numbers in the footer, then... Wait, did I miss something? Is there a second part coming, or was that it? Double-click directly into the footer on the page, then dig through the options until you find the setting you're looking for. It’s all in there. Link to the Previous SectionGo ahead and click that. You’ll want to follow the exact same steps on the third page as well. Once you're done with that, give it a shot and try deleting the page numbers. 😍 As for the second part regarding the text, it’s the exact same deal. Just click on the header at the top of the page, select "Link to Previous" again, and then go ahead and delete everything you don't actually need. Why make it more complicated than it has to be?