Home
Knowledge Base
Create a Ticket
Check Existing Ticket
Home
Knowledge Base
Create a Ticket
Check Existing Ticket
Home
Knowledge Base
Create a Ticket
Check Existing Ticket
Found Articles
×
  • Welcome to our Support Desk

    In order to streamline support requests and better serve you, we utilize a support ticket system. Every support request is assigned a unique ticket number which you can use to track the progress and responses online. A valid email address is required to use this system.

    NOTE: Tickets are answered in the order they are received. Please do not submit multiple tickets, as this may delay our response. You can expect a response within 1 business day, but most tickets are answered the same day.

    Please note that we have recently migrated to this new support center. Any tickets older than 1/28/14 will not be found here. We apologize for any inconvenience. If you have not had a response to a ticket that was submitted previously, you may resubmit the ticket and we will get back to you right away.

    Support

    Do you have a question?

    Simply submit a ticket and one of our support
    representatives will be in touch shortly to help you.

     

    Do you have an existing ticket?

    No problem. You can see the status, check for
    updates, and read all of your existing tickets.

    Create A Ticket   Check Existing Ticket

     


     


     


     


     
  • Create a New Ticket

    Note: If you've already created a ticket and just want to check the status of that ticket, click here.

    Rob Swanson Support Center Form

    Add Attachment
    Please enter 21159 into the box below to submit your ticket:
    Most Asked Questions
    Videos Won't Play

    There are a couple reasons you may be experiencing this issue. I would suggest the following options. You may have already tried these suggestions, so I will list them below.

    1. Reload the page, click play and then as the video starts to play, click pause. Allow the video to load fully before watching any of the video. Once it has fully loaded, press play.

    2. Switch to a different internet browser. I tested in Google Chrome, Firefox and Internet Explorer and the video played for me.

    3. Check your flash player for updates. Click this link: http://get.adobe.com/flashplayer/ and it should let you know if your flash player is out of date and needs to be updated.

    It also could have been caused by a glitch in your internet connection, which is the most common cause for this issue. If this was the case, you should be able to watch the video in its entirety by using option 1 above.


    How to combine cells in Excel

    In this example we will combine cells A1 & B1.

    First, add a column to the spreadsheet. Then write this formula into the first field in this column:

    =A1&" "&B1&""

    Hit enter and you will see the new data in this field. (i.e. A1 B1)

    Then copy this formula down the column by double clicking the bottom right hand corner of the cell (i.e. on the box that you would otherwise drag).

    Once you have copied the formula down the field, you will need to copy/the column and then Paste As and select Paste Values so that you will have the actual text in the field and not just the formula.

    Then save your file.


    How To Clear Your Cache

    Here are instructions to clear your cache for each of the browsers:

    Internet Explorer 9 and 8

    * Click Tools, and select Delete Browsing History... .
    * Deselect Preserve Favorites website data, and select Temporary Internet files, Cookies, and History.
    * Click Delete.

    Internet Explorer 7

    * From the Tools menu in the upper right, select Delete Browsing History... .
    * To delete your cache, click Delete files... . To delete your cookies, click Delete cookies... .
    * To delete your history, click Delete history... .
    * Click Close, and then click OK to exit.

    Firefox

    * The following instructions apply to Firefox 3.5 and later.
    * From the Tools menu, select Clear Recent History. (Alternatively, in Firefox 4 and above for Windows, you can also click the orange Firefox button, and then select Clear Recent History from the History menu.) If the menu bar is hidden, press Alt to make it visible.
    * From the Time range to clear: drop-down menu, select the desired range; to clear your entire cache, select Everything.
    * Click the down arrow next to "Details" to choose which elements of the history to clear. Click Clear Now.

    Chrome

    * In the browser bar, enter: chrome://settings/clearBrowserData
    * Select the items you want to clear (e.g., Clear browsing history, Clear download history, Empty the cache, Delete cookies and other site and plug-in data). From the Obliterate the following items from: drop-down menu, you can choose the period of time for which you want to clear cached information. To clear your entire cache, select the beginning of time.
    * Click Clear browsing data.

    Opera

    * From the Opera menu, select Settings, and then Delete Private Data... .
    * In the dialog box that opens, select the items you want to clear, and then click Delete.

    Safari

    * From the Safari menu, select Reset Safari... .
    * From the menu, select the items you want to reset, and then click Reset. As of Safari 5.1, Remove all website data covers both cookies and cache.


    Copy cell values, not formulas

     

    Sometimes, when you copy the contents of a cell, you want to paste just the value and not the underlying formula that is displayed in the formula bar.

    For example, you might want to copy the resulting value of a formula to a cell on another worksheet. Or you might want to delete the values that you used in a formula after you copied the resulting value to another cell on the worksheet. Both of these actions cause an invalid cell reference error (#REF!) error to appear in the destination cell, because the cells that contain the values that you used in the formula can no longer be referenced.

    You can avoid this error by pasting the resulting values of formulas without the formula in destination cells.

    1. On a worksheet, select the cells that contain the resulting values of a formula that you want to copy.
    2. On the Home tab, in the Clipboard group, click Copy .

    Keyboard shortcut  You can also press CTRL+C.

    1. Select the upper-left cell of the paste area.

    Tip    To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

    1. On the Home tab, in the Clipboard group, click Paste , and then click Paste Values.


    Opening Spreadsheets on a Mac

    The spreadsheet files are Microsoft Excel files, so you will need to either open with Office for Mac, or you can also upload to Google drive and use it the same way. Here is a tutorial for how to use Google Drive:1. Let's say you have an Excel spreadsheet you want to edit where ever you are without a need for having Microsoft Office installed.

    2. Open Google Docs homepage, click here to go there. Login to you Google account if asked so.

    3. In Google Docs homepage click Upload button next to Create and choose Files...

    4. Browse and double click the document you want to import to Google Docs.

    5. Choose the Convert documents, presentations, spreadsheets to Google Docs format option and click Start upload.

    6. When upload is complete, click to open the file you just uploaded.

    7. And there's your spreadsheet with most of the formatting and calculation formulas included. Majority of the Excel formulas and function should be able to work in Google Docs as well.

    8. And there's an imported Excel spreadsheet (now a Google Docs spreadsheet) among your other Google Docs documents.

    You can also import Microsoft Word document and Microsoft PowerPoint document and turn in to a Google Docs document the same way we did it in this tutorial. All you need is a computer, tablet or a smartphone and a working Internet connection and you can work with your documents online in Google Docs.


    View More Questions

     
  • Live Chat

    Most Asked Questions
    Videos Won't Play

    There are a couple reasons you may be experiencing this issue. I would suggest the following options. You may have already tried these suggestions, so I will list them below.

    1. Reload the page, click play and then as the video starts to play, click pause. Allow the video to load fully before watching any of the video. Once it has fully loaded, press play.

    2. Switch to a different internet browser. I tested in Google Chrome, Firefox and Internet Explorer and the video played for me.

    3. Check your flash player for updates. Click this link: http://get.adobe.com/flashplayer/ and it should let you know if your flash player is out of date and needs to be updated.

    It also could have been caused by a glitch in your internet connection, which is the most common cause for this issue. If this was the case, you should be able to watch the video in its entirety by using option 1 above.


    How to combine cells in Excel

    In this example we will combine cells A1 & B1.

    First, add a column to the spreadsheet. Then write this formula into the first field in this column:

    =A1&" "&B1&""

    Hit enter and you will see the new data in this field. (i.e. A1 B1)

    Then copy this formula down the column by double clicking the bottom right hand corner of the cell (i.e. on the box that you would otherwise drag).

    Once you have copied the formula down the field, you will need to copy/the column and then Paste As and select Paste Values so that you will have the actual text in the field and not just the formula.

    Then save your file.


    How To Clear Your Cache

    Here are instructions to clear your cache for each of the browsers:

    Internet Explorer 9 and 8

    * Click Tools, and select Delete Browsing History... .
    * Deselect Preserve Favorites website data, and select Temporary Internet files, Cookies, and History.
    * Click Delete.

    Internet Explorer 7

    * From the Tools menu in the upper right, select Delete Browsing History... .
    * To delete your cache, click Delete files... . To delete your cookies, click Delete cookies... .
    * To delete your history, click Delete history... .
    * Click Close, and then click OK to exit.

    Firefox

    * The following instructions apply to Firefox 3.5 and later.
    * From the Tools menu, select Clear Recent History. (Alternatively, in Firefox 4 and above for Windows, you can also click the orange Firefox button, and then select Clear Recent History from the History menu.) If the menu bar is hidden, press Alt to make it visible.
    * From the Time range to clear: drop-down menu, select the desired range; to clear your entire cache, select Everything.
    * Click the down arrow next to "Details" to choose which elements of the history to clear. Click Clear Now.

    Chrome

    * In the browser bar, enter: chrome://settings/clearBrowserData
    * Select the items you want to clear (e.g., Clear browsing history, Clear download history, Empty the cache, Delete cookies and other site and plug-in data). From the Obliterate the following items from: drop-down menu, you can choose the period of time for which you want to clear cached information. To clear your entire cache, select the beginning of time.
    * Click Clear browsing data.

    Opera

    * From the Opera menu, select Settings, and then Delete Private Data... .
    * In the dialog box that opens, select the items you want to clear, and then click Delete.

    Safari

    * From the Safari menu, select Reset Safari... .
    * From the menu, select the items you want to reset, and then click Reset. As of Safari 5.1, Remove all website data covers both cookies and cache.


    Copy cell values, not formulas

     

    Sometimes, when you copy the contents of a cell, you want to paste just the value and not the underlying formula that is displayed in the formula bar.

    For example, you might want to copy the resulting value of a formula to a cell on another worksheet. Or you might want to delete the values that you used in a formula after you copied the resulting value to another cell on the worksheet. Both of these actions cause an invalid cell reference error (#REF!) error to appear in the destination cell, because the cells that contain the values that you used in the formula can no longer be referenced.

    You can avoid this error by pasting the resulting values of formulas without the formula in destination cells.

    1. On a worksheet, select the cells that contain the resulting values of a formula that you want to copy.
    2. On the Home tab, in the Clipboard group, click Copy .

    Keyboard shortcut  You can also press CTRL+C.

    1. Select the upper-left cell of the paste area.

    Tip    To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area.

    1. On the Home tab, in the Clipboard group, click Paste , and then click Paste Values.


    Opening Spreadsheets on a Mac

    The spreadsheet files are Microsoft Excel files, so you will need to either open with Office for Mac, or you can also upload to Google drive and use it the same way. Here is a tutorial for how to use Google Drive:1. Let's say you have an Excel spreadsheet you want to edit where ever you are without a need for having Microsoft Office installed.

    2. Open Google Docs homepage, click here to go there. Login to you Google account if asked so.

    3. In Google Docs homepage click Upload button next to Create and choose Files...

    4. Browse and double click the document you want to import to Google Docs.

    5. Choose the Convert documents, presentations, spreadsheets to Google Docs format option and click Start upload.

    6. When upload is complete, click to open the file you just uploaded.

    7. And there's your spreadsheet with most of the formatting and calculation formulas included. Majority of the Excel formulas and function should be able to work in Google Docs as well.

    8. And there's an imported Excel spreadsheet (now a Google Docs spreadsheet) among your other Google Docs documents.

    You can also import Microsoft Word document and Microsoft PowerPoint document and turn in to a Google Docs document the same way we did it in this tutorial. All you need is a computer, tablet or a smartphone and a working Internet connection and you can work with your documents online in Google Docs.


    View More Questions
  • Check Existing Ticket

    If you've already created a ticket and just need to check the status of that ticket, simply enter the email address you used to create the ticket below and click the button.

  • Click Here to Reset the Header

    You can customize the header by uploading two separate files.

    The background image and goes from the left side to the right side or the screen.

    The header image should contain your companies logo and anything else you wish to put on it. It will lay on top of the background image.

    The header image should be 1138 pixels wide and the same height as the background.
    Anything smaller than 1138 pixels will work as well (It centered across the top.)

    Below is an example of what your background image could look like:


    Below is an example of a header image. Note that it has a transparent background as it will lay on top of the background above (not required):


    Background Image:

    Header Image:

  • Edit Knowledge Base Articles


    Article Name Assigned Category Priority URL Hits T
    Videos Won't PlayVideos View251T
    How To Clear Your CacheBrowser Issues View128T
    Opening Spreadsheets on a MacBrowser Issues View76T
    How to combine cells in ExcelSpreadsheets View179T
    Copy cell values, not formulasSpreadsheets View84T
×

Link directly to this article:


Link directly to the contents of this article only:

×

T Are you sure you want to delete this article?

  ×

Edit Category


Category Name:

×