I'm having a problem with spreedsheets on which I am using format painter. I am copying data into a spreadsheet and then a use the format painter from a previous spreadsheet. It works fine. The problem comes in when I try to save the second spreadsheet with the new format. It doesn't work. When I pull it back up it does not have the format that I've "painted" onto it. Any ideas what I'm doing wrong? Thanks.
Aren't you on the wrong forum?
cdayton wrote:
Aren't you on the wrong forum?
Look again his post is in the chit-chat forum?
I've never seen that. Maybe there's something incompatible between the worksheet that you are getting the format from and the second worksheet that you are trying to save. Could the source worksheet have been created in a different version of Excel? Are you painting font formats for fonts that are not installed on your system? You might also check to make sure that the file being saved after formatting is the same one being opened after saving. Use "save as" with revised file name and revised directory location to confirm.
I'm a heavy user of the MS "suite" at my day job.
That's typical of Excel and (even more so) Powerpoint - in fact all Microshaft products.
There are problems which can be attributed to version differences, and problems I can't even explain.
Getting colors and formats to match after copy/paste can be almost impossible at times.
rfcoakley wrote:
I've never seen that. Maybe there's something incompatible between the worksheet that you are getting the format from and the second worksheet that you are trying to save. Could the source worksheet have been created in a different version of Excel? Are you painting font formats for fonts that are not installed on your system? You might also check to make sure that the file being saved after formatting is the same one being opened after saving. Use "save as" with revised file name and revised directory location to confirm.
I've never seen that. Maybe there's something inc... (
show quote)
The original file is an .xlsx file. The file that I copied the data into is a .csv file, but I've tried to copy it as a .xlsx file. The original file came from the same source. I'm not sure how I got in into the .xlsx format solely. When I do try to copy it as an xlsx file it comes up .xlsx.csv.
The thing that I really don't understand is that I can make the format changes and use them while I'm in the spreadsheet, but I can't save the changes. I would have to manually put in the format changes in order retain them in the new sheet, even though they would be exactly the same as what was copied.
Try Saving (not copying) your *.csv as *xlsx.
csv files aren't big on formatting,they just care about the number of items and commas per "line".
Then try the copy/paste.
What kind of data is it, why did you choose csv??
tbpmusic wrote:
Try Saving (not copying) your *.csv as *xlsx.
csv files aren't big on formatting,they just care about the number of items and commas per "line".
Then try the copy/paste.
What kind of data is it, why did you choose csv??
I've tried that. It's bank information that allows me to save it into Excel. When I do, though, it does so as a .csv document. When I try to save it as an *xlsx document, it saves it as an *xlsx.csv
Try editing the file name to remove the ".csv".
with a *.csv file opened in Excel, you should be able to select "Save As" and utilize the expansion menu under "Save As" to choose the specific format that you want to use. The one to choose is "Excel Workbook." The proper extension is automatically appended to the file name that you choose. So, if you started with "myfile.csv" and then did a "Save As" using the "Excel Workbook" option in the expansion menu and named the file "newfile," (don't name it "newfile.xlsx"), you should see "newfile.xlsx" in the directory where you saved it.
rfcoakley wrote:
with a *.csv file opened in Excel, you should be able to select "Save As" and utilize the expansion menu under "Save As" to choose the specific format that you want to use. The one to choose is "Excel Workbook." The proper extension is automatically appended to the file name that you choose. So, if you started with "myfile.csv" and then did a "Save As" using the "Excel Workbook" option in the expansion menu and named the file "newfile," (don't name it "newfile.xlsx"), you should see "newfile.xlsx" in the directory where you saved it.
with a *.csv file opened in Excel, you should be a... (
show quote)
That did it. When I selected it from the pull down menu rather than try to attach the extension myself, it did the trick.
Now I've got to try to figure out why my printer no longer recognizes my printer. At least I have the manual and I've had this problem before.
CPR
Loc: Nature Coast of Florida
Glad you found the answer for Excel. For the printer, check that you're selecting the Printer on the network and not just the Printer. Had that problem a number of times.
CPR wrote:
Glad you found the answer for Excel. For the printer, check that you're selecting the Printer on the network and not just the Printer. Had that problem a number of times.
It's been working. The other day was the first time that the connection was lost. I've had it happen before with this Brother printer and have had to re-establish the connection through the printer.
CPR
Loc: Nature Coast of Florida
Never used a Brother Printer, I've been using EPSON since it was an 8 dot matrix connected to the parallel port of the pc and they have served well.
CPR wrote:
Never used a Brother Printer, I've been using EPSON since it was an 8 dot matrix connected to the parallel port of the pc and they have served well.
It's a b&w printer only. I found that printing text on a color printer was terribly costly in color ink and I couldn't understand it. This printer does cut down on the costs but it does have its drawbacks, one being that it will only print one envelope at a time and you basically have to re-configure the back of the machine to do that. I didn't know that when I bought it. That IS one problem of comparing printers online only and making your purchase online.
If you want to reply, then
register here. Registration is free and your account is created instantly, so you can post right away.