Thursday, March 31, 2016

How to Fix - Adding a date in two calculations, firstly 28 days, second calculation for 6 months?

Adding a date in two calculations, firstly 28 days, second calculation for 6 months

I have a specific date which alters dependent upon the person for a renewal scheme, i need to add 6 months to this renewal date and i also need to run a secon calculation for 28 days for the renewal process.
I am running 2007, the formulas online dont
seem to work.
Stumped.

Solutions to the Problem Adding a date in two calculations, firstly 28 days, second calculation for 6 months

Download SmartPCFixer for Free Now

Hi, not sure what you need, let' say you have a date in cell A2 and want to add 28 days, just do
=A2+28
or
=A2+180   to add 6 month

Run CHKDSK
  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Reboot your computer.

Another Safe way to Repair the Problem: Adding a date in two calculations, firstly 28 days, second calculation for 6 months:

How to Fix Adding a date in two calculations, firstly 28 days, second calculation for 6 months with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for your computer. The errors will be shown in the list.

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

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Adobe Setup Error 1402 \"Could not open key\" when trying to install CS4 [Solved],Adobe Reader 9 and Windows 7 [Anwsered],Solution to Error: adobe flash player is not recognized by my computer.,How to Fix Error - Add-on button missing after upgrading to IE10.?,Troubleshooter of Error: Administrator profile will not load in Win 7 and all suggested repairs not working HELP!,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How to Fix Error - Adding Check boxes to MS Word 2007?

Adding Check boxes to MS Word 2007

Hi there-

I have been given a project at work that I truly have no idea where to start.
I am trying to add check boxes to a document in MS Word 2007.
I understand how to insert them, however I am hoping to add a little more to it.
I would like some kind of functionality
where when someone checks a box, additional text comes up that will allow the user to answer more questions, and will disappear if they uncheck the box.
Is this even something that can be done in MS Word? I am feeling entirely overwhelmed and my searches have
been fruitless so far.
Any help will be greatly appreciated.

Keys to the Problem Adding Check boxes to MS Word 2007

Download Error Fixer (Free)

What you ask is certainly possible, but how you approach it would rather depend on what the end result is intended to be and how the end result will be used.

If the aim is to produce a document that is to be printed with values in the document dependent on selections made, then I would be inclined not to use check boxes in the document, but to create a userform in which the user makes the selections and from there
the document is created according to the selections made.


See http://www.gmayor.com/Userform.htm and then when you have the idea of the concept in mind, you can move on to

http://gregmaxey.mvps.org/word_tip_pages/populate_userform_listbox_or_combobox.html

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Recommended Method to Repair the Problem: Adding Check boxes to MS Word 2007:

How to Fix Adding Check boxes to MS Word 2007 with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The junk files 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 finished, 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, junk file cleaning and print spooler error repair.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Problem: Adobe Flash Player problems With Internet Explorer,How to Fix - Add or Remove Snap-ins does not appear on the file menu of Computer Management or any other console.?,Tech Support: adding photo attachments (sent to me) to my photo gallery,ads connection error - Each ad shows \"Internet Explorer can not display webpage\",How Can I Fix - AdobeAir\/Adobe Flash Player Install problems?,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Adjusting volume causes Windows Explorer to freeze Tech Support

Adjusting volume causes Windows Explorer to freeze

Hello all,

An issue that I continue to encounter is one that involves the volume controls on my laptop.
 Every now and then, when I attempt to adjust the volume of my computer, Windows Explorer will freeze.
 When I attempt to click on the explorer bar, I am informed
that "Windows has stopped working", and I am given the option of restarting it, closing it, or waiting for it to respond.
 I can close or restart it and the bar will unfreeze, but any time I attempt to adjust the volume after this first occurrence will result
in another freeze.
 Adjusting the volume by the physical volume knob on my laptop or the virtual volume mixer will produce the same result.

Here are some specs...

Software:  Windows 7 home premium (32-bit)
Hardware: Toshiba Satellite A205-S4577

This is an issue that occurs erratically, but tends to happen more frequently when the laptop is unplugged.

Can anyone provide any advice?

Solutions to the Problem Adjusting volume causes Windows Explorer to freeze

Download SmartPCFixer for Free Now

Thank you, Pranav-

I actually received a response from Windows Technical Support earlier and it solved the issue!

In this case, they advised that I:

First, back up all files.
 

Next, do a quick virus scan to search for threats.
 A few should be ok, but 10 or more is an issue.

Then, do a system file scan to search for any system files that may be corrupted.
 The scan will detect and repair them.
 To do so:
Open an elevated command prompt.
To do this, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
If you
are prompted for an administrator password or for a confirmation, type the password, or click Allow.At the command prompt, type the following command, and then press ENTER: sfc /scannow

And that solved it for me!

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Recommended Method to Fix the Problem: Adjusting volume causes Windows Explorer to freeze:

How to Fix Adjusting volume causes Windows Explorer to freeze with SmartPCFixer?

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

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooting:After being online a while the back button stops working in IE 8,Troubleshoot:after i get past andministrator's password, what do i do next?We'll search for answers Error,How to Fix Problem - After changing my windows theme to a classic non-aero custom theme, I cannot open any folder anywhere without explorer crashing?,Troubleshooter of Error: Advanced filters criteria: difference between H3=LARGE($H$3:$H$133;5) and H3=LARGE(H3:H133;5),Troubleshoot:Aero - Menu bar has stopped working,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

ADODB.Connection for Access 2007 database [Solved]

ADODB.Connection for Access 2007 database

Can you help me please.
I am tring to make a connection to a 2007 format access database.
The code I picked up from a previous answer works fine with an .mdb database but not with a .accdb.
 How should I amend the code please
 
Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long
    ' move to data return sheet
    
    ' connect to the Access database
    Set cn = New ADODB.Connection
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
        "Data Source=D:\documents\Jam\CTS\Community Vision\August 11\temp.mdb;"
    ' open a recordset
    Set rs = New ADODB.Recordset
    rs.Open "sheet1", cn, adOpenKeyset, adLockOptimistic, adCmdTable
 
Thanks
 
Judith

Keys to the Problem ADODB.Connection for Access 2007 database

Download SmartPCFixer for Free Now

cn.Open "Provider=Microsoft.ACE.OLEDB.12.0; " & _
        "Data Source=D:\documents\Jam\CTS\Community Vision\August 11\temp.accdb;"

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.

Another Safe way to Repair the Problem: ADODB.Connection for Access 2007 database:

How to Fix ADODB.Connection for Access 2007 database with SmartPCFixer?

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

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

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


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Troubleshooter of Error: Adobe flashplayer 10,Troubleshooting:After every login I get \" You must restart your computer to apply these changes\" Error,How to Resolve - After I didn't agree to pay for help on internet \"JUST ANSWER\" ,my internet log in for google became corrupted?,How to Fix Problem - adobe acrobat cannot find DDE Server?,After formatting a 16GB drive to NTFS, my drive went to 8MB. HOW TO FIX? Tech Support,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How to Resolve - Adding a Data Table that is showing one specific information?

Adding a Data Table that is showing one specific information

I have the sales figures of my top product portfolio for years 2009- 2010.
In the chart I would like to show just the volume increase-decrease on the chart without ´percentages in a secondary axis.
But I would like to add a Data Table below that the chart
that is showing deviation between these 2 years as a percentage.



2009
2010
Dev.
2010-2009

k
100
130
30%

m
50
60
20%

n
75
80
7%


 
the number are comparised on the chart whereas percentage is wriite below the chart.
Thanks

Keys to the Problem Adding a Data Table that is showing one specific information

Download SmartPCFixer to Fix It (Free)

You will not be able to add specific data tables, the data tables will be corresponding to the chart information
You may refer the link mentioned below, might be helpful
http://office.microsoft.com/en-us/excel-help/show-or-hide-a-chart-legend-or-data-table-HP010007432.aspx

Run CHKDSK

  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Reboot your computer.
An error might pop up:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

  • Go to theStart button.
  • Go to "All Programs > Accessories" and right click on "Command Prompt".
  • Select "Run as Administrator".
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Reboot your computer.

Recommended Method to Repair the Problem: Adding a Data Table that is showing one specific information:

How to Fix Adding a Data Table that is showing one specific information with SmartPCFixer?

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

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: [Solved] After a virus attack, my windows media player got removed. Now I'm unable to reinstall it...,Solution to Error: After connecting to someone on Skype, I receive a blue screen, Error code: 0x0000007E,Tech Support: Adding new data for a spreadsheet to the master spreadsheet.,Solution to Problem: adobe premier elements corrupts WMV files,How to Fix Error - Adobe Acrobat has taken over my computer. All files are trying to open in Adobe.?,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Adding the "move window" function in the the Task Bar [Solved]

Adding the "move window" function in the the Task Bar

In Windows XP, there was a previous option of moving the window when right clicking on an application in the taskbar.  This was especially helpful when using dual monitors, one as a primary and ocassionally using the secondary.  When the second monitor
is off, applications still load in that space, so the move function in the taskbar, was a quick way to get the application back into the primary monitor.  For the most part, I enjoy the new task bar (except for the removal of quick launch, which fortuantely
has a workaround).

Is there a way to get the move function back when right clicking on an application?  The workaround I use now is using keyboard shortcuts, but takes more time and requires memorizing the shortcut (alt-space, down arrow, hold direction arrow wanted).

Keys to the Problem Adding the "move window" function in the the Task Bar

Download SmartPCFixer to Fix It (Free)

Isn't still available?

Hover your mouse over the tasbar icon of the application (the thumbnail preview appears) > right click on the thumbnail preview > select Move > hold the button and move the window.

Use the System File Checker tool to repair corrupted or missing system files:

  1. Click Start.
  2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
  3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
  4. Type or copy paste the below command line into it without quotes:
  5. "Sfc /scannow"

Recommended Method to Repair the Problem: Adding the "move window" function in the the Task Bar:

How to Fix Adding the "move window" function in the the Task Bar with SmartPCFixer?

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

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: After an auto update from Windows 8 to 8.1 my display is continuously flickering. [Solved],[Solved] Adobe PDF Maker not working.....,Troubleshooting:Adobe reader 8.1 has stop working but does not update,Fast Solution to Error: Add-in available for managing hidden text?,[Solved] Advanced filter on a different sheet,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Adding a choice to a drop-down list within a template-style workbook [Solved]

Adding a choice to a drop-down list within a template-style workbook

I have created an Excel Workbook that is a template for another user.  Within the workbook, I have various drop-down lists.  I created these using another worksheet in the same workbook (by defining the list and then using the data validation tool). 
I want to allow users of this workbook to be able to add additional items to the drop-down lists without needing to first add to the list on the other worksheet.  Is it possible to add to these drop-down lists by typing directly into the drop-down cell (have
the information automatically populate into the list)?
Thanks!

Solutions to the Problem Adding a choice to a drop-down list within a template-style workbook

Download Error Fixer (Free)

With the built in feature, we can only limit the user entering the data in excel using the data validation.
However, this may be possible using VBA code.

Sachin Shetty

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Recommended Method to Repair the Problem: Adding a choice to a drop-down list within a template-style workbook:

How to Fix Adding a choice to a drop-down list within a template-style workbook with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your system. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be repaired. 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 removed.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Adding saved shortcuts to internet explorer from documents folder [Solved],[Solved] Adobe PDF Maker not working.....,Solution to Problem: Additional log on information may be required. Click to open your browser after running Windows Updates today. 11\/13\/12,[Solved] Advance Registry Optimizer 2010 is installed but I didn't download it,Solution to Error: Aero Snap does not work with mouse pointer, although keyboard shortcuts work fine.________,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

How to Fix - After I did a system restore the compatablity changed. What happened??

After I did a system restore the compatablity changed. What happened?

I got a virus so I restored my computer to a previous date of the day before.
When it finished I had noticed desktop icons are gone and almost everything I download cant run and says "The version of this file is not compatible with the version of windows
you are running.
Check your computer's system information to see weather you need x86 (32-Bit) or x86 (64-bit) versions of the program and contact the software publisher."
 
This is happening to a lot of programs that worked fine before.
I just bought this computer and use it mainly for gaming.
I paid a lot of money for it so I would assume it comes with a 64 bit operating system, but when I go to the setting my only options
are 16 and 32 bit.

Anwsers to the Problem After I did a system restore the compatablity changed. What happened?

Download Error Fixer for Free Now

Windows Error Reporting - To Fix After I did a system restore the compatablity changed. What happened?

  1. Go to Start button.
  2. Open Control Panel.
  3. Go to Windows Error Reporting.
  4. Click on System and Maintenance, then click Problem Reports and Solutions.
  5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
  6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
  7. Next, click the Advanced settings link.
  8. Select Off to turn off Error Reporting.

Another Safe way to Repair the Problem: After I did a system restore the compatablity changed. What happened?:

How to Fix After I did a system restore the compatablity changed. What happened? with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for your computer. The junk files will be shown in the scan result.

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 removed.


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Error: adsl modem getting hanged while using with usb,How Can I Fix - Advanced filtering Macro does not work afther recording.?,After getting a Blue Screen error, I cannot start XP Mode, get error \"The virtual machine could not be registered because the configuration file does not exist\" Tech Support,Solution to Error: ADDRESS BAR NOT WORKING,Solution to Error: After a virus infection, App Data/Roaming/swcltb.dll is missing from my computer, and fan usage 100% all the time,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded

Troubleshoot:Address Change in Excel Database to Word Label Doc Merge

Address Change in Excel Database to Word Label Doc Merge

My question has to do with changes/updates to data fields in a labels Mail Merge between Excel and Word.  I have an Excel address database that I use each year for my holiday cards.  I have merged it to a Word labels document.  I thought that if I made changes
to the Excel database (i.e., someone has moved and has a new address), that those changes would automatically show up in the Word Labels doc that is associated with that Excel database.  I made a change to the Excel database to test this theory and it did
not work. 
 
Does anyone know why this did not work -- or how I make it work?
 
Thanks very much!

Solutions to the Problem Address Change in Excel Database to Word Label Doc Merge

Download SmartPCFixer for Free Now

If you mean the document that results from finishing the mail merge, that is static - it won't reflect changes in the source data.
If you still have the merge document that contains the merge fields, you can run the mail merge again, and the document generated by this will be up-to-date for this year.

Tweak IE Options
  • Open Internet Explorer.
  • Go to "Tools > Internet Options > Advanced Tab".
  • Uncheck "Enable third-party browser extensions".
  • Click "Apply".
  • Reboot your computer.

Recommended Method to Fix the Problem: Address Change in Excel Database to Word Label Doc Merge:

How to Fix Address Change in Excel Database to Word Label Doc Merge with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

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

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed


Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: How to Fix - addresss bar doesn't change to green colour - When logging into encrypted \/ secure websites?,Solution to Problem: Additional log on information may be required. Click to open your browser after running Windows Updates today. 11\/13\/12,adding text from combobox to a table using append query [Solved],Troubleshoot:Add or remove programs? Uninstall says not valid or data has been corrupted, will not continue. Error,Fast Solution to Problem: Adding two worksheets cells values causing #REF error,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded