Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Problem
I have a user that has two excel 2007 spread sheets open and copies from one
sheet to another he saves it then opens it the next day and all the fonts have disappears. Any ideas??? More back ground, He had this problem in office 2K3 so I decided to upgrade him to 2K7 because we were only 3 departments from doing that anyhow but it seem to follow him. so just for S&G's we loaded him on another PC and the same problem stands, so we ruled out local software and PC it has to be with the system. I had an Excel guy come and look to see what he was doing to make sure it wasn't a PEBKAC error. The excel guy said it has to be the file. More info he does export from SAP to Excel then adds color and changed fonts size. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Problem
"ID10T" wrote...
I have a user that has two excel 2007 spread sheets open and copies from one sheet to another he saves it then opens it the next day and all the fonts have disappears. Any ideas??? .... What file format is he using when saving the files? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Problem
We are have tried both XLS and XLSX |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Problem
"ID10T" wrote...
We are have tried both XLS and XLSX If he's saving to XLSX, and the XLSX file also loses formatting, then it shouldn't be due to macros since XLSX file (in theory) shouldn't be able to save VBA modules. In that case, if the user's lost formatting may actually be a true bug in Excel itself. Last thing I can think to try would be saving the file TWICE, to different drives, using a different filename for the second save. After the second save, the open file should still show the user's formatting. Open the file it was first saved as. Does that file still have the user's formatting? If so. exit Excel, relaunch Excel and open each of the saved files. Do they still show the user's formatting? If the file saved first opens without the user's formatting, close it and copy the second saved file (still open in Excel, so you many need to use a console window to do that using a command prompt copy command) to the first file, overwriting it. Then open that file again. If it's still lacking the user's formatting, then it'd appear Excel isn't saving the user's formatting when it saves the file, and that's seem to be a bug in Excel. The last possibility I can think of is that the user's formatting could be conditional formatting that's triggered by a formula that relies on state information that's TRUE when the user creates the formatting but FALSE when the user reopens the files. So is the lost formatting simple formatting or conditional formatting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem loading Excel 2007 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel |