One way I found around the cut and paste formatting issue is to open up a blank excel workbook, paste your text or numeric values into an unformatted cell, then cut and paste from there back into the template. If the text is longer than a few words, I also needed to format the cell in the blank workbook so that the text wrapped within it. It's an annoying extra step, but this has worked for me and others who were encountering the same issue. Hope it does for you as well. Ricky -----Original Message----- From: Research Administration List [mailto:xxxxxx@hrinet.org] On Behalf Of Lesley Zajac Sent: Tuesday, September 22, 2009 10:54 AM To: xxxxxx@hrinet.org Subject: Re: [RESADM-L] Fed Reporting Excel Templates No I was not able to unlock the file in order to cut and paste. Lesley S. Zajac Director, Research Administration Jaeb Center for Health Research 15310 Amberly Drive, Ste 350 Tampa, FL 33647 Tel: 813.975.8690 Fax: 813.975.8761 email: xxxxxx@jaeb.org -----Original Message----- From: Research Administration List [mailto:xxxxxx@hrinet.org] On Behalf Of Key, Diana Sent: Tuesday, September 22, 2009 10:32 AM To: xxxxxx@hrinet.org Subject: Re: [RESADM-L] Fed Reporting Excel Templates Aggravated is right! I knew it didn't sound right and even asked Rick to check to be sure he was telling me right. He came back and assured me he was right. I won't be chatting with them anymore, since I can't trust what is said. Now, back to my original problem--has anyone been able to unlock the spreadsheet to cut/paste the description info?? Diana Diana L. Key Associate Director Sponsored Research Services Florida State University 874 Traditions Way Tallahassee, FL 32306-4166 P: 850-644-8648 F: 850-644-1464 -----Original Message----- From: Research Administration List [mailto:xxxxxx@hrinet.org] On Behalf Of Gina Hedberg Sent: Tuesday, September 22, 2009 10:17 AM To: xxxxxx@hrinet.org Subject: Re: [RESADM-L] Fed Reporting Excel Templates To all aggravated ARRA-reporting members, I just had an exchange with Dominique at the help desk on FederalReporting.gov. She told me the current version CAN be used. Like many of you, we have already downloaded and pre-filled the forms. What a absolute pain it would be to have to start all over on October 1! Leslie, I hope this gives you some relief and allows you to focus on your son's wedding. Gina Gina Hedberg Director Office of Grants Administration AD 200 University of South Alabama Mobile, AL 36688 251-460-7888 251-414-8296 (fax) >>> Lesley Zajac <xxxxxx@JAEB.ORG> 9/22/2009 8:28 AM >>> This is unbelievable. I just spent a day or two prefilling the forms with the information that I could put in ahead of time. And now come to find out the forms are less than useless. I have exactly Oct 1 and 2 to file my reports before I go on vacation for my son's wedding. Not having access to the forms until 10/1 really cuts down on the time I have to finish the reports. I wonder if federalreporting.gov will bottleneck as we all try to get online to get the forms???? Diana - thank you so much for passing this information on. Just goes to show the value of the colleagues on this list and that we only have ourselves to rely on for timely information. Lesley S. Zajac Director, Research Administration Jaeb Center for Health Research 15310 Amberly Drive, Ste 350 Tampa, FL 33647 Tel: 813.975.8690 Fax: 813.975.8761 email: xxxxxx@jaeb.org -----Original Message----- From: Research Administration List [mailto:xxxxxx@hrinet.org] On Behalf Of Key, Diana Sent: Tuesday, September 22, 2009 9:05 AM To: xxxxxx@hrinet.org Subject: [RESADM-L] Fed Reporting Excel Templates I just got off a chat with the help desk at FederalReporting.gov. I was told that the excel templates available today are just a model and if we tried to upload them on 10/1 they would be rejected. He said that the "real" templates will not be available until 10/1. Attached is a snapshot of my session with Rick. What do you think?? Diana Diana L. Key Associate Director Sponsored Research Services Florida State University 874 Traditions Way Tallahassee, FL 32306-4166 P: 850-644-8648 F: 850-644-1464 ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ====================================================================== ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ====================================================================== ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ====================================================================== ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ====================================================================== ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ====================================================================== ====================================================================== Instructions on how to use the RESADM-L Mailing List, including subscription information and a web-searchable archive, are available via our web site at http://www.hrinet.org (click on "Listserv Lists") ======================================================================
