TryingMyBest
New Member
- Joined
- Dec 9, 2005
- Messages
- 4
I am having mucho problems because of Excel's 255 character limit when copying an entire spreadsheet to a new workbook.
Does anyone have ideas/code to circumvent it?
In a nutshell, I copy a "data entry" page onto a “report” page within a workbook. The entire “report” page is then copied and moved into a new workbook. That allows me to have a stand alone, exported file outside of my main data entry tool. When you copy an entire page to a new workbook, Excel imposes a 255 character limit. Thus, I see truncated responses on the exported spreadsheet only.
Thanks!!
Does anyone have ideas/code to circumvent it?
In a nutshell, I copy a "data entry" page onto a “report” page within a workbook. The entire “report” page is then copied and moved into a new workbook. That allows me to have a stand alone, exported file outside of my main data entry tool. When you copy an entire page to a new workbook, Excel imposes a 255 character limit. Thus, I see truncated responses on the exported spreadsheet only.
Thanks!!