Microsoft Office Q&A: General Discussion (Word, Excel, PowerPoint...)

Jack Smith5 said:can anyone whip this up in Word? or maybe some other program?

Here's the file OVDJE if it works for you. Just track down a Chinese font and tweak it however you want.

I'm having an issue with Google Docs. Someone was messing around on my computer earlier and must have tweaked some settings because everything looks messed up now. There’s this weird little dot sitting in the middle of the line between every single word—not a regular period, but one of those tiny ones that sits in the center. On top of that, every time I hit enter for a new line, this symbol pops up that looks like a backwards letter P. How do I get rid of this junk?

I'm using the 2007 version.

http://office.microsoft.com/en-us/tr...aspx?section=4

Here we go again. This stuff keeps popping up on my screen and it’s driving me absolutely insane. I found some explanation online about how to get rid of it, but following their steps is useless because the option they're talking about isn't even there... 😕

To view formatting marks, use the ribbon at the top of the window. On the Home tab in the Paragraph group, click the Show/Hide button. Click the button again to hide the formatting marks.

I don't see this show/hide option anywhere... 🤷

Alright, I finally figured it out on my own. 😁

One click and everything is back to normal...

Kyle Johnson2 said:Here’s the file OVDJE if this works for you. Just track down whatever Chinese font you need and tweak it however you like.

That should do it, thanks a million!
Best,👍

Hey everyone,

I have a bit of a question for the group... I was wondering if there might be a way to set things up so that if, say, I enter a specific number or a date into cell A1, then cell B1 becomes essentially locked down so nothing can be typed there?
Basically, I'm looking to disable any input in cell B1 whenever cell A1 contains a number, and perhaps even flip the logic so it works the other way around too, if that's even possible.

thanks

cosmicbison19 said:Got a question... is there a way that if I, say, type a number or date into cell A1, then nothing can be typed into cell B1? Basically, block B1 from being edited if A1 has a number, and vice versa.

You didn't really explain what you need here. Why does B1 matter so much, and does it *have* to have data in it if A1 is empty?

Theoretically, you could block entry in B1 by unlocking everything on the Sheet except locking just B1 and then using Protect Sheet (password or whatever). You could also set it so you can't even select B1.

There's a way to do it via Data Validation where you pick the Custom option and use a formula like =IF(A1="";"";""), plus an input message, but since I don't know the full story, I can't give you a definitive answer.

So... I was thinking about this as a sort of digital ledger.
The idea is that if someone types something into A1, just so we don't have any forgetful moments where things get skipped, it should then move on to B1—but at that point, B1 should lock itself up, and vice versa.
Basically, both A1 and B1 start out unlocked.
If there’s a number sitting in A1, B1 locks down, and if there’s a number in B1, A1 gets locked.
For the time being, I've been hacking my way through this using Conditional Formatting, so if there's a value in A1, B1 just turns black, and then it works the other way around.

I gave Data Validation a shot just now using the formula =IF(A1="";"";"")
And honestly, it actually works!
thanks

Kyle Johnson2 said:You haven't quite laid everything out. I suppose I'm wondering why cell B1 is so critical, or if it needs to hold specific data, like if cell A1 happens to be empty.

In theory, you could just prevent anyone from entering anything into cell B1 by unlocking all the cells on the Sheet except for locking cell B1 specifically, and then just applying Protect Sheet (whether you use a password or not). You could even set it up so that cell B1 can't even be selected in the first place.

There is also a possibility using Data Validation where you select the Custom option and plug in the formula =IF(A1="";"";""), and maybe add an input message, though I don't fully grasp the entire scope of the issue, so I can't say for certain.

I know I’m basically digging this topic up from the grave...

Admins, if I’ve posted this in the wrong spot, please feel free to move it for me.

I’m running into a headache with the Table of Contents in Word 2003—for some reason, every single chapter keeps showing up as being on page 2.
I try updating the table, and everything looks perfect for a second—so then I save the file, but the moment I reopen it, the whole issue comes right back.

Does anyone know how to actually fix this?

Greetings—I have a question that might seem a bit trivial: how can I save a single file to two different locations at once?
To be specific, I update an Excel Workbook on my local machine, but after I input the values and hit save, I also need to copy that file over to our company server.
Is there a built-in option within Excel to automatically create a "duplicate" upon saving, or am I stuck doing this manually every time?

driftingangler11 said:Hey there—I might be asking something kind of silly here, but how do I save a single file to two different locations at once?

Just use Save As... 😕

goldenharbor62 said:Same thing here. I update the sheet, everything looks fine, hit save... then I reopen the file and the damn issue is right back where I left it.

Can you just upload that doc somewhere so I can grab it?

driftingangler11 said:Got a potentially stupid question: how do I save one file to two different spots?

No such thing as a stupid question 😉

If you want to save an updated Workbook to its original spot AND somewhere else at the same time, just use a Macro.

Just copy this Macro into the VBE = of the specific file.
Change the path where you want the copy to go (like C:\Temp\ in this example)
Once you hit Save, the updated file saves normally, and a backup automatically pops up at that other location.

Code:

Kyle Johnson2 said:There’s no such thing as a stupid question. 😉

If you need to save an updated Workbook to both its original directory and a secondary location simultaneously, you can easily automate the process using a Macro.

Copy This Macro in VBE => ThisWorkbook affects the specific files.
Update the file copy path (in this instance, C:\Temp\).
Once you hit Save, an updated copy will automatically be generated at the specified file path.

Kod:

Private Sub Workbook_BeforeSave(ByVal _
SaveAsUI As Boolean, Cancel As Boolean)
With ThisWorkbook
.SaveCopyAs ("C:\Users\Public\Documents\Backup of " & .Name)
End With
End Sub

Hold on a second... that's not working quite right—please create a backup in the same location.
So, if I have this right: you put the file path inside quotation marks, follow it with an ampersand, and then add the filename—is that the correct way to structure it?

driftingangler11 said:Hold up... that’s not how it works—it should just make a backup in the same folder.

Just swap out that C:\Temp part and nothing else. Just the file path.
btw: Check out the tutorial and you'll see it works fine. 😉

Kyle Johnson2 said:Just swap out whatever is listed after C:\Temp—leave everything else alone. You just need to update the file path.
btw: Check out this tutorial to see how it works. 😉

Look, I can only tell you one thing: on my machine, it saves to the exact same folder where I opened the xls, and the only adjustment I made was changing "c:\" to "d:\" since my C drive is my system drive and all my data lives on D. 😢
I've checked the temp folder, and there's absolutely nothing there. 😢

Maybe it’s an issue with Windows 7 or Office 2003, but I even tried typing the full filename manually based on the tutorial:
ActiveWorkbook.SaveCopyAs "D:\TEMP\testfile.xls"

Still nothing. 😢

driftingangler11 said:Look—all I can tell you again is that for me, it’s dropping it in the EXACT same folder where I launched the xls, ...................ActiveWorkbook.SaveCopyAs "D:\TEMP\test.xls"
still nothing works

Man, you're still not listening to me. Just do what I told you.

Here is what you currently have in your Macro:

Code:

Just swap out the path. Leave everything else alone.

Code:

this specific part => Backup of " & .Name) => DO NOT TOUCH 😉

Hi everyone...😁
I am running into an issue with Microsoft Office 2003. I recently finished installing it on my system, and then this pops up. 😕
http://imageshack.us/photo/my-images/801/bezimenac.png/

I guess there's a way to handle this when you have a 15-page paper and need the numbering to start on page three, leaving the first two pages blank. 🤷