Panduit Easymark does not acknowledge Excel 2010

SOURCE: Sorting Imported sql data

Are you sure you imported the data or did you create a link to sql. If it is a link then it will not allow you to work with a subset of the data because it would effect the data on the sql database.

Tim Babcock

• 2794 Answers
• Posted on Jun 10, 2008

SOURCE: import data from access into excel where one column go into one worksheet and other into next

Can't be done.

Access will only put the data into one worksheet. It is very picky when it comes to exporting data into an Excel spreadsheet.

There are two ways to get around it:

1) You can export the data from Access into two files. One for the the first worksheet and another file for the second workshet.

2) You can import everything into one spreadsheet and build a macro into Excel to cut the information one spreadsheet and paste it into the other if this is a redundant task to do all the time.

Hope that helps you out.

SOURCE: Excel 2000 Issue???

.Let's start with this for more info:
Is the URL icon there but blank? (Maybe an X in the middle of the box?) If it's there, do the following:

Right-click on the URL
2. Select Hyperlink from the menu that appears
3. Is Remove Hyperlink box checked or unchecked?

This is a setting that is machine-specific. Post the answer as a comment and we'll take the next step if necessary

SOURCE: Autofilter ceases to work on large Excel 2003 spreadsheet

Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

SOURCE: I need to be able to scroll Excel 2007 spreadsheets

hold your ctrl key & then scroll
it works