Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Next
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
Twitch
YouTube
Facebook (EN Publishing)
Facebook (EN World)
Twitter
Instagram
TikTok
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Community
General Tabletop Discussion
*Dungeons & Dragons
ForgedAnvil D&D 5E Character Generator
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="ForgedAnvil" data-source="post: 6576345" data-attributes="member: 6791775"><p>That's about the extent of it!</p><p></p><p>For Windows users running Excel 2010-2013</p><p></p><p>Option 1</p><p>1. Open old and new character file</p><p>2. Snap old file to left of window, new file to right of window</p><p>3. Start copying and pasting or typing in single values</p><p>- I use a lot of Copy then Paste Special > Values (as long as the copy size and paste size are the same).</p><p> In doing so you avoid copying any formatting that may be different to the new file (and may cause issues)</p><p> This is useful in places where you may have large areas of data such as on Character Sheet II, III and IV.</p><p>- For any formulas you've used, use the Copy then Paste Special > Formulas </p><p></p><p>Usually takes me a minute or 2 to update</p><p></p><p>Option 2 (for many character updates)</p><p>1. Put all OLD Characters and the NEW temple in the same directory. Open one OLD file and the NEW template file</p><p> 2. Snap OLD file to left of window, NEW file to right of window</p><p>3. Copy from OLD file to NEW file using Paste Special > Link (should look like this =['ForgedAnvil Character Generator 1.21 Example Character - Zenith.xlsm]Start'!H12)</p><p>4. Close the <strong>OLD </strong> file and the links will change to look like =C:\Users\ForgedAnvil\Documents\D&D\['ForgedAnvil Character Generator 1.21 Example Character - Zenith.xlsm]Start'!H12</p><p>5. Save the NEW file as a new name e.g. Zenith - Wizard Level 8.xlsm</p><p>6. Open up next "OLD" character to transfer, snap to left</p><p>7. Select NEW Zenith - Wizard Level 8.xlsm file</p><p>8. Find and replace "ForgedAnvil Character Generator 1.21 Example Character - Zenith.xlsm" with OLD file name in the same directory</p><p>9. Voila, everything should be updated to the next Character</p><p>10. File > Save As > Rename</p><p>11. Repeat steps 5 through 7 keeping in mind the filename changes</p><p>12. Once you have all your Characters transferred, when you open them you may get a warning about updating links. You should now Break Links with any external file by going to Data tab in the ribbon> Edit Links > Highlight the external file and click the Break Link. All links should now be values (if you used formulas then you will need to re-enter those)</p><p></p><p>May save you a bit of time if you have many characters to transfer</p><p></p><p>Hope this helps</p><p></p><p>Cheers</p><p>ForgedAnvil</p></blockquote><p></p>
[QUOTE="ForgedAnvil, post: 6576345, member: 6791775"] That's about the extent of it! For Windows users running Excel 2010-2013 Option 1 1. Open old and new character file 2. Snap old file to left of window, new file to right of window 3. Start copying and pasting or typing in single values - I use a lot of Copy then Paste Special > Values (as long as the copy size and paste size are the same). In doing so you avoid copying any formatting that may be different to the new file (and may cause issues) This is useful in places where you may have large areas of data such as on Character Sheet II, III and IV. - For any formulas you've used, use the Copy then Paste Special > Formulas Usually takes me a minute or 2 to update Option 2 (for many character updates) 1. Put all OLD Characters and the NEW temple in the same directory. Open one OLD file and the NEW template file 2. Snap OLD file to left of window, NEW file to right of window 3. Copy from OLD file to NEW file using Paste Special > Link (should look like this =['ForgedAnvil Character Generator 1.21 Example Character - Zenith.xlsm]Start'!H12) 4. Close the [B]OLD [/B] file and the links will change to look like =C:\Users\ForgedAnvil\Documents\D&D\['ForgedAnvil Character Generator 1.21 Example Character - Zenith.xlsm]Start'!H12 5. Save the NEW file as a new name e.g. Zenith - Wizard Level 8.xlsm 6. Open up next "OLD" character to transfer, snap to left 7. Select NEW Zenith - Wizard Level 8.xlsm file 8. Find and replace "ForgedAnvil Character Generator 1.21 Example Character - Zenith.xlsm" with OLD file name in the same directory 9. Voila, everything should be updated to the next Character 10. File > Save As > Rename 11. Repeat steps 5 through 7 keeping in mind the filename changes 12. Once you have all your Characters transferred, when you open them you may get a warning about updating links. You should now Break Links with any external file by going to Data tab in the ribbon> Edit Links > Highlight the external file and click the Break Link. All links should now be values (if you used formulas then you will need to re-enter those) May save you a bit of time if you have many characters to transfer Hope this helps Cheers ForgedAnvil [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
ForgedAnvil D&D 5E Character Generator
Top