Home |
Search |
Today's Posts |
#1
|
|||
|
|||
xp excel
I have dual boot up..
win 98se using office 2000 and xp with office xp... the 2 problems that I experience are..... excel sheets created in the 2000 suite are all colour coded to the cell values using conditional formatting....these are visible whilst veiwing the sheet on screen......whenever I try to open these sheets in the xp suite I can not see the formatting unless I use the print preview option...this does not happen when opening the sheets in xp on my laptop,,,the colours are visible.... I have checked that the excel options are setup the same for both machines.... the other problem I have been getting is that in office 2000, I could open a large collection of files and these would open and update through an odbc link without having to enter the datea password for each file....every time I try to open these files in the xp suite, I am prompted to enable background refresh, as these files are numerous and opened and refreshed constantly, is there a command I can enable to do a background refresh.... any help would be appreciated -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
Hi Phil
does http://support.microsoft.com/default...b;en-us;320531 Apply? Cheers JulieD "phil Evans via OfficeKB.com" wrote in message ... I have dual boot up.. win 98se using office 2000 and xp with office xp... the 2 problems that I experience are..... excel sheets created in the 2000 suite are all colour coded to the cell values using conditional formatting....these are visible whilst veiwing the sheet on screen......whenever I try to open these sheets in the xp suite I can not see the formatting unless I use the print preview option...this does not happen when opening the sheets in xp on my laptop,,,the colours are visible.... I have checked that the excel options are setup the same for both machines.... the other problem I have been getting is that in office 2000, I could open a large collection of files and these would open and update through an odbc link without having to enter the datea password for each file....every time I try to open these files in the xp suite, I am prompted to enable background refresh, as these files are numerous and opened and refreshed constantly, is there a command I can enable to do a background refresh.... any help would be appreciated -- Message posted via http://www.officekb.com |
#3
|
|||
|
|||
This worked a treat ......Thanks Julie
Also found the solution to the refresh problem......Ms article 248204 for anybody else experiencing the same type of problem... Phil -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
html to excel | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Shortcut file fails to open | Excel Discussion (Misc queries) |