Disk Cleaner can Speed Up Your Windows: 7월 2016

2016년 7월 6일 수요일

automatic progressive invoice numbers in excel 2007 [Solved]

automatic progressive invoice numbers in excel 2007

I'm trying to set up an invoice in excel 2007 I would like the invoice numbers (i.e.
001/12/12AM) to automatically change after each save.
Is this possible? It would make it easier to use rather than having to enter each progressive number manually.

TI want it to automatically change for each new invoice.

The format of invoice is find below

Date
17/12/12

Invoice no.
001/12/LAA

Payment Terms:
50% Advance & balance before dispatch

Solutions to the Problem automatic progressive invoice numbers in excel 2007

Download Error Fixer for Free Now

Please can you explain how you want your invoice numbers to increment? It's not clear to me from your post.

001/12/LAA -->> ???/??/??? -->> ???/??/??? -->> ???/??/???....

I think your best bet is to save your file as a .xltm (macro enabled template file).

You could add code like this to the ThisWorkbook module so that a cell of your choice (A1 in this example) is updated with the new number (in this case dd/mm/LAA, where dd is the date and mm is the month):

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1").Value = Format(Now(), "dd/mm") & "/LAA"
End Sub

Each time you double-click on the template file a new .xlsx file will be created. When you save it as .xlsx, the macro will be removed and so the cell wouldn't be updated if you were to open the file in the future.

Hope that helps.

Cheers
Rich

Download the Microsoft Windows ISO (installation device) from the following website:
http://www.microsoft.com/en-us/software-download/windows10
Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
Extract the ISO file to a separate USB device or burn the program to a compact disc.
Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Back up during sleep mode

I use Carbonite back up during at midnight. However, with inactivity in the evening my PC sleeps and loses it internet connection. How do I overcome this problem? Can I retain internet connection during sleep?

Anwsers to the Problem Back up during sleep mode

Download SmartPCFixer to Fix It (Free)

Hi bobct321,
You cannot use internet connection during sleep mode.

Sleep is a power-saving state.
Sleep saves all open documents and programs, and allows the computer to quickly resume full-power operation (typically within several seconds) when you want to start working again.
Putting your computer to sleep is like pausing
a DVD player: the computer immediately stops what it’s doing and is ready to start again when you want to resume working.
To put your computer to sleep, click the Power button on the
Start menu or click the arrow next to the Lock button .

The Sleep option is located on the Lock menu

You can typically put a mobile PC to sleep by closing its lid.
Some computers also have a physical sleep button on their cases, often located near the power switch.
Depending on your computer's power management settings, you computer may also automatically go to sleep after a period of inactivity to conserve energy.
To adjust these settings, see
Change, create, or delete a power plan (scheme).
While your computer is asleep, its hardware lights may slowly flash or change color.
This is normal.
On most computers, you can resume working by pressing the power button.
However, not all computers are the same.
You may be able to wake your computer by pressing keys on the keyboard, clicking your mouse button, or opening the lid on a mobile PC.
Check
the documentation that came with your computer, or go to the manufacturer's website.
For more information visit
http://windows.microsoft.com/en-US/windows7/Turn-off-a-computer-frequently-asked-questions
Hope this information is helpful.

Umesh P - Microsoft Support

System Update Readiness Command: To Fix Back up during sleep mode

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Back up during sleep mode in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Reboot your Windows & see if error Back up during sleep mode is still there.

Note: Your administrator's password might be needed.

Apps/software not performing well

many apps like firefox ,bluestacks don't close & take too much time to start,
whenever I try to close them by ending their process they don't
I got another problem with a app bluestacks sometimes it starts within seconds ,sometimes it takes too much time
& I click on it's tray Icon it doesn't responds ,but when hibernate/sleep my laptop & then resume it again I get whole meun on my screen ,& after that it works properly ,

Keys to the Problem Apps/software not performing well

Download Error Fixer for Free Now

Using Windows troubleshooter:

Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
A new window will open. Click View all from the left pane.
Scroll down to the bottom and click on Windows update.
Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
The troubleshooter will automatically detect problems and fix it.
Now, close this window and try download/install the app which was previously showing error.

Backup issues with windows 7

The action center keeps telling me to backup comp. I install blank dvd and proceed with backup. It takes a very long time(overnite to go from25% to 31%). What I think is happening is the dvd is filling up and there is no contingency to close of that
dvd and install another. It will not go past 31% complete no matter how long I give it. I eventuall have to stop backup and when I try to eject it I am unable.

Keys to the Problem Backup issues with windows 7

Download Error Fixer (Free)

Hi Cshep11,

What are you trying to back up (the full system image or a few files and folder)?
Time taken to backup would depend on the number of files and the size of the files.

If you have any security software installed on the computer it would take longer for the backup center to backup files.
Try to disable security software and try to take a backup and verify.

If that works fine later enable the security software.
Follow the link for more information
http://windows.microsoft.com/en-US/windows7/Disable-antivirus-software

Also try to run a Check disk for the hard drive and check if that helps
To run Check disk
1.       Open Computer by clicking the
Start button, and then clicking Computer.

2.       Right-click the hard disk drive that you want to check, and then click
Properties.
3.       Click the
Tools tab, and then, under Error-checking, click
Check Now. If you are prompted for an administrator password or confirmation, type the password or provide confirmation.
To automatically repair problems with files and folders that the scan detects, select
Automatically fix file system errors.
Otherwise, the disk check will simply report problems but not fix them.
To perform a thorough disk check, select Scan for and attempt recovery of bad sectors.
This scan attempts to find and repair physical errors on the hard disk itself, and it can take much longer to complete.
To check for both file errors and physical errors, select both
Automatically fix file system errors and Scan for and attempt recovery of bad sectors.
4.       Click
Start.
Depending upon the size of your hard disk, this may take several minutes.
For best results, don't use your computer for any other tasks while it's checking for errors.

For information follow the link
http://windows.microsoft.com/en-us/windows-vista/Check-your-hard-disk-for-errors

After you perform a check disk try running the backup process and check if that helps.

Hope this information is helpful.

Amrita M
Microsoft Answers Support Engineer
Visit our Microsoft Answers Feedback Forum and let us know what you think.

Check if there are memory problems

Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.

Click on the Start button on the Taskbar.
Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
Click on Windows Memory Diagnostic Tool (in the search results).
Click on "Restart now and check for problems (Recommended)".
The system will restart, and you need to follow the instructions given on the screen.

Attempting to run CS6 premiere pro: Configuration error, please uninstall and reinstall the product, Error: 1

So I have installed CS6 on my Z210 Windows 7 workstation.
But when I go to open up half of the programs, particularly premier pro I get this message...

Configuration error

Please uninstall and reinstall the product.

If this problem still occurs, please contact Adobe technical support for help, and

mention the error code shown at the bottom of this screen.

Error: 1

http://www.adobe.com/support/

I could really use some help here.
What really makes me mad is apparently Adobe customer service is not taking any calls.
Are you kidding me?
Any help would greatly be appreciated.

I found a similar situation here on this forum but am still having issues:

http://www.techyv.com/questions/adobe-photoshop-cs6-error-code-1

Solutions to the Problem Attempting to run CS6 premiere pro: Configuration error, please uninstall and reinstall the product, Error: 1

Download SmartPCFixer for Free Now

Hi,

Method 1:

I would suggest you to run the FIXIT from the link provided and check if it helps.

Fix problems with programs that can't be installed or uninstalled

http://support.microsoft.com/mats/program_install_and_uninstall/

Method 2:

If the issue still persists, you may start the computer in a clean boot state and then try installing the program.

This could be happening if any of the background programs is conflicting with the smooth running of your computer.
To help troubleshoot error messages and other issues, you can start Windows 7 by using a minimal set of drivers and startup programs.
This
kind of startup is known as a "clean boot." A clean boot helps eliminate software conflicts.

How to troubleshoot a problem by performing a clean boot in Windows Vista or in Windows 7
http://support.microsoft.com/kb/929135

Note: After you have finished troubleshooting, follow step 7 mentioned in the article to boot the computer to normal startup.

Hope this helps and keep us posted if you need further assistance.

Manually editing the Windows registry

Manually editing the Windows registry to remove invalid MACHINE_CHECK_EXCEPTION keys is not recommended unless you are PC service professional. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system. In fact, one misplaced comma can prevent your PC from booting entirely!

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to MACHINE_CHECK_EXCEPTION (eg. Windows Operating System):

Click the Start button.
Type "command" in the search box... DO NOT hit ENTER yet!
While holding CTRL-Shift on your keyboard, hit ENTER.
You will be prompted with a permission dialog box.
Click Yes.
A black box will open with a blinking cursor.
Type "regedit" and hit ENTER.
In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
From the File menu, choose Export.
In the Save In list, select the folder where you want to save the Windows Operating System backup key.
In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
In the Export Range box, be sure that "Selected branch" is selected.
Click Save.
The file is then saved with a .reg file extension.
You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed?

Magic-I-3 fr Arc Soft worked fine on Vista ever since on 7 pro ,program cannot find Virtual Driver
any service pack needed or just incompatible with 7.Multiple installs tried
already

Keys to the Problem Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed?

Download SmartPCFixer for Free Now

Ask ArcSoft if there is an update to their program.

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

If your computer meets the minimum requirements above, then continue on…

Another Safe way to Repair the Problem: Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed?:

How to Fix Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will scan your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Troubleshoot:Auto-export of graph slopes?

Auto-export of graph slopes?

If I want to link an excel field to a slope of a specific graph, which keeps automatically updating if the graph changes, how can I do that?
Sure, I can create an Array, that also gives me the slope, STDEV, and such of the original data, but can I similarly link an excel box to a graph slope (or other graph feature, such as label text etc.)

Keys to the Problem Auto-export of graph slopes?

Download Error Fixer for Free Now

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
16 GB available hard disk space (32-bit) or 20 GB (64-bit)

If your computer meets the minimum requirements above, then continue on…

Another Safe way to Fix the Problem: Auto-export of graph slopes?:

How to Fix Auto-export of graph slopes? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer. Open it, and it will scan your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

How to Resolve - Autofill, cell references?

Autofill, cell references

Keys to the Problem Autofill, cell references

Download SmartPCFixer for Free Now

Hey, I usually drag the formula in the first cell and excel changes the cell numbers/references itself.
But now I am trying to multiply a whole series with a particular cell.ie B1 – B10 with only A1 but auto fill changes the references automatically
- B1 with A1, B2 with A2 & so forth..
How do I do this??
Use $ signs to freeze either the column or row or both.
For example, if you were dragging your formula and you wanted each formula to always reference cell A1 in each new formula, you would use $A$1 and no matter which way you dragged, that reference would
not change.
You do not have to put $ signs on both elements of the address...
it depends on what part you need frozen and which direction you plan to drag the formula.
This is called absolute referencing as opposed to what you do now which is called relative
referencing...
you might want to look these terms up in the help files (or google for them) in order to learn more about them.

And also please do tell what’s the command to run excel from run?
I am not sure what you are referring to here...
can you provide more description please.

Manually editing the Windows registry to fix Error Autofill, cell references

Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

Click the Start button.
Type "command" in the search box... DO NOT hit ENTER yet!
While holding CTRL-Shift on your keyboard, hit ENTER.
You will be prompted with a permission dialog box.
Click Yes.
A black box will open with a blinking cursor.
Type "regedit" and hit ENTER.
In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
From the File menu, choose Export.
In the Save In list, select the folder where you want to save the Windows Operating System backup key.
In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
In the Export Range box, be sure that "Selected branch" is selected.
Click Save.
The file is then saved with a .reg file extension.
You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

Another Safe way to Fix the Problem: Autofill, cell references:

How to Fix Autofill, cell references with SmartPCFixer?

1. Download Error Fixer. Install it on your system.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.

Troubleshooting:Avery Wizard business card

Avery Wizard business card

I have created a label using Avery Wizard.
I did not find a way to save it until after I instructed it to print a full page of labels.
When I opened the file again I was only able to print a full page and not use the same design to print only a few.
Please
tell me I do not need to redesign the label every time I want a different number of labels.
How can I avoid this?

Anwsers to the Problem Avery Wizard business card

Download Error Fixer (Free)

Hi,

Thank you for posting this question.
As I understand you would like to re-use the business card after the mailmerge.

Let me help you in this issue.
Once you finish the mail merge, save the document as a template so that you can use it repeatedly.

Go to File > Click on Save as > Choose Word template.

I hope this helps you.

Don't Download Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.

Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

2016년 7월 6일 수요일

automatic progressive invoice numbers in excel 2007

Solutions to the Problem automatic progressive invoice numbers in excel 2007

Recommended Method to Repair the Problem: automatic progressive invoice numbers in excel 2007:

How to Fix automatic progressive invoice numbers in excel 2007 with SmartPCFixer?

Back up during sleep mode

Anwsers to the Problem Back up during sleep mode

System Update Readiness Command: To Fix Back up during sleep mode

Recommended Method to Repair the Problem: Back up during sleep mode:

How to Fix Back up during sleep mode with SmartPCFixer?

Apps/software not performing well

Keys to the Problem Apps/software not performing well

Using Windows troubleshooter:

Recommended Method to Fix the Problem: Apps/software not performing well:

How to Fix Apps/software not performing well with SmartPCFixer?

Backup issues with windows 7

Keys to the Problem Backup issues with windows 7

Check if there are memory problems

Recommended Method to Repair the Problem: Backup issues with windows 7:

How to Fix Backup issues with windows 7 with SmartPCFixer?

Attempting to run CS6 premiere pro: Configuration error, please uninstall and reinstall the product, Error: 1

Solutions to the Problem Attempting to run CS6 premiere pro: Configuration error, please uninstall and reinstall the product, Error: 1

Recommended Method to Repair the Problem: Attempting to run CS6 premiere pro: Configuration error, please uninstall and reinstall the product, Error: 1:

How to Fix Attempting to run CS6 premiere pro: Configuration error, please uninstall and reinstall the product, Error: 1 with SmartPCFixer?

Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed?

Keys to the Problem Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed?

Check Windows System Requirements

Another Safe way to Repair the Problem: Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed?:

How to Fix Arc Soft Magic-I 3.Worked fine on Vista ,Program asking for virtual driver since on 7 pro__ after mult,installations any service pack needed? with SmartPCFixer?

Auto-export of graph slopes?

Keys to the Problem Auto-export of graph slopes?

Check Windows System Requirements

Another Safe way to Fix the Problem: Auto-export of graph slopes?:

How to Fix Auto-export of graph slopes? with SmartPCFixer?

Autofill, cell references

Keys to the Problem Autofill, cell references

Another Safe way to Fix the Problem: Autofill, cell references:

How to Fix Autofill, cell references with SmartPCFixer?

Avery Wizard business card

Anwsers to the Problem Avery Wizard business card

Don't Download Malware

Recommended Method to Repair the Problem: Avery Wizard business card:

How to Fix Avery Wizard business card with SmartPCFixer?