Question about Microsoft Excel for PC
When importing data from Excel 2010 spreadsheet to Panduit Easy Mark a message appears saying "you must install Excel"
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.
Posted on Apr 13, 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.
Posted on Jun 10, 2008
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
Posted on Apr 02, 2009
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.
Posted on Jun 18, 2009
SOURCE: I need to be able to scroll Excel 2007 spreadsheets
hold your ctrl key & then scroll
it works
Posted on Aug 25, 2009
76 views
Usually answered in minutes!
×